Pandas Profiling Report

Dataset statistics

Number of variables	176
Number of observations	23432
Missing cells	5
Missing cells (%)	< 0.1%
Duplicate rows	51
Duplicate rows (%)	0.2%
Total size in memory	31.5 MiB
Average record size in memory	1.4 KiB

Variable types

CAT	160
BOOL	14
NUM	2

Warnings

Dataset has 51 (0.2%) duplicate rows	Duplicates
`pax_name` has a high cardinality: 20972 distinct values	High cardinality
`pax_passport` has a high cardinality: 21075 distinct values	High cardinality
`seg_dep_time` has a high cardinality: 5655 distinct values	High cardinality
`birth_date` has a high cardinality: 2915 distinct values	High cardinality
`nation_name` has a high cardinality: 56 distinct values	High cardinality
`city_name` has a high cardinality: 298 distinct values	High cardinality
`province_name` has a high cardinality: 88 distinct values	High cardinality
`pref_orig_m3_1` has a high cardinality: 63 distinct values	High cardinality
`pref_orig_m3_2` has a high cardinality: 84 distinct values	High cardinality
`pref_orig_m3_3` has a high cardinality: 68 distinct values	High cardinality
`pref_orig_m3_4` has a high cardinality: 56 distinct values	High cardinality
`pref_orig_m3_5` has a high cardinality: 51 distinct values	High cardinality
`pref_orig_m6_1` has a high cardinality: 73 distinct values	High cardinality
`pref_orig_m6_2` has a high cardinality: 100 distinct values	High cardinality
`pref_orig_m6_3` has a high cardinality: 89 distinct values	High cardinality
`pref_orig_m6_4` has a high cardinality: 80 distinct values	High cardinality
`pref_orig_m6_5` has a high cardinality: 67 distinct values	High cardinality
`pref_orig_y1_1` has a high cardinality: 80 distinct values	High cardinality
`pref_orig_y1_2` has a high cardinality: 116 distinct values	High cardinality
`pref_orig_y1_3` has a high cardinality: 118 distinct values	High cardinality
`pref_orig_y1_4` has a high cardinality: 94 distinct values	High cardinality
`pref_orig_y1_5` has a high cardinality: 87 distinct values	High cardinality
`pref_orig_y2_1` has a high cardinality: 79 distinct values	High cardinality
`pref_orig_y2_2` has a high cardinality: 131 distinct values	High cardinality
`pref_orig_y2_3` has a high cardinality: 134 distinct values	High cardinality
`pref_orig_y2_4` has a high cardinality: 120 distinct values	High cardinality
`pref_orig_y2_5` has a high cardinality: 102 distinct values	High cardinality
`pref_orig_y3_1` has a high cardinality: 73 distinct values	High cardinality
`pref_orig_y3_2` has a high cardinality: 130 distinct values	High cardinality
`pref_orig_y3_3` has a high cardinality: 141 distinct values	High cardinality
`pref_orig_y3_4` has a high cardinality: 132 distinct values	High cardinality
`pref_orig_y3_5` has a high cardinality: 108 distinct values	High cardinality
`pref_line_m3_1` has a high cardinality: 176 distinct values	High cardinality
`pref_line_m3_2` has a high cardinality: 195 distinct values	High cardinality
`pref_line_m3_3` has a high cardinality: 155 distinct values	High cardinality
`pref_line_m3_4` has a high cardinality: 140 distinct values	High cardinality
`pref_line_m3_5` has a high cardinality: 108 distinct values	High cardinality
`pref_line_m6_1` has a high cardinality: 219 distinct values	High cardinality
`pref_line_m6_2` has a high cardinality: 269 distinct values	High cardinality
`pref_line_m6_3` has a high cardinality: 224 distinct values	High cardinality
`pref_line_m6_4` has a high cardinality: 198 distinct values	High cardinality
`pref_line_m6_5` has a high cardinality: 161 distinct values	High cardinality
`pref_line_y1_1` has a high cardinality: 282 distinct values	High cardinality
`pref_line_y1_2` has a high cardinality: 334 distinct values	High cardinality
`pref_line_y1_3` has a high cardinality: 306 distinct values	High cardinality
`pref_line_y1_4` has a high cardinality: 288 distinct values	High cardinality
`pref_line_y1_5` has a high cardinality: 242 distinct values	High cardinality
`pref_line_y2_1` has a high cardinality: 322 distinct values	High cardinality
`pref_line_y2_2` has a high cardinality: 377 distinct values	High cardinality
`pref_line_y2_3` has a high cardinality: 411 distinct values	High cardinality
`pref_line_y2_4` has a high cardinality: 390 distinct values	High cardinality
`pref_line_y2_5` has a high cardinality: 348 distinct values	High cardinality
`pref_line_y3_1` has a high cardinality: 312 distinct values	High cardinality
`pref_line_y3_2` has a high cardinality: 379 distinct values	High cardinality
`pref_line_y3_3` has a high cardinality: 442 distinct values	High cardinality
`pref_line_y3_4` has a high cardinality: 435 distinct values	High cardinality
`pref_line_y3_5` has a high cardinality: 394 distinct values	High cardinality
`pref_city_m3_1` has a high cardinality: 61 distinct values	High cardinality
`pref_city_m3_2` has a high cardinality: 84 distinct values	High cardinality
`pref_city_m3_3` has a high cardinality: 68 distinct values	High cardinality
`pref_city_m3_4` has a high cardinality: 56 distinct values	High cardinality
`pref_city_m6_1` has a high cardinality: 76 distinct values	High cardinality
`pref_city_m6_2` has a high cardinality: 103 distinct values	High cardinality
`pref_city_m6_3` has a high cardinality: 89 distinct values	High cardinality
`pref_city_m6_4` has a high cardinality: 74 distinct values	High cardinality
`pref_city_m6_5` has a high cardinality: 64 distinct values	High cardinality
`pref_city_y1_1` has a high cardinality: 92 distinct values	High cardinality
`pref_city_y1_2` has a high cardinality: 123 distinct values	High cardinality
`pref_city_y1_3` has a high cardinality: 119 distinct values	High cardinality
`pref_city_y1_4` has a high cardinality: 107 distinct values	High cardinality
`pref_city_y1_5` has a high cardinality: 98 distinct values	High cardinality
`pref_city_y2_1` has a high cardinality: 85 distinct values	High cardinality
`pref_city_y2_2` has a high cardinality: 127 distinct values	High cardinality
`pref_city_y2_3` has a high cardinality: 141 distinct values	High cardinality
`pref_city_y2_4` has a high cardinality: 132 distinct values	High cardinality
`pref_city_y2_5` has a high cardinality: 107 distinct values	High cardinality
`pref_city_y3_1` has a high cardinality: 78 distinct values	High cardinality
`pref_city_y3_2` has a high cardinality: 130 distinct values	High cardinality
`pref_city_y3_3` has a high cardinality: 149 distinct values	High cardinality
`pref_city_y3_4` has a high cardinality: 146 distinct values	High cardinality
`pref_city_y3_5` has a high cardinality: 116 distinct values	High cardinality
`recent_flt_day` has a high cardinality: 994 distinct values	High cardinality
`pref_orig_city_m3` has a high cardinality: 76 distinct values	High cardinality
`pref_orig_city_m6` has a high cardinality: 90 distinct values	High cardinality
`pref_orig_city_y1` has a high cardinality: 102 distinct values	High cardinality
`pref_orig_city_y2` has a high cardinality: 104 distinct values	High cardinality
`pref_orig_city_y3` has a high cardinality: 102 distinct values	High cardinality
`pref_dest_city_m3` has a high cardinality: 77 distinct values	High cardinality
`pref_dest_city_m6` has a high cardinality: 90 distinct values	High cardinality
`pref_dest_city_y1` has a high cardinality: 94 distinct values	High cardinality
`pref_dest_city_y2` has a high cardinality: 95 distinct values	High cardinality
`pref_dest_city_y3` has a high cardinality: 89 distinct values	High cardinality
`cabin_hf_cnt_m6` is highly correlated with `cabin_hf_cnt_m3`	High correlation
`cabin_hf_cnt_m3` is highly correlated with `cabin_hf_cnt_m6`	High correlation
`cabin_fall_cnt_y1` is highly correlated with `cabin_fall_cnt_m6`	High correlation
`cabin_fall_cnt_m6` is highly correlated with `cabin_fall_cnt_y1`	High correlation
`pit_add_buy_cnt_y1` is highly correlated with `pit_add_buy_amt_y1`	High correlation
`pit_add_buy_amt_y1` is highly correlated with `pit_add_buy_cnt_y1`	High correlation
`pit_add_buy_cnt_y3` is highly correlated with `pit_add_buy_cnt_y2`	High correlation
`pit_add_buy_cnt_y2` is highly correlated with `pit_add_buy_cnt_y3`	High correlation
`pit_des_upg_cnt_m3` is highly correlated with `pit_des_upg_amt_m3`	High correlation
`pit_des_upg_amt_m3` is highly correlated with `pit_des_upg_cnt_m3`	High correlation
`pit_income_cnt_m3` is highly correlated with `pit_accu_cnt_m3`	High correlation
`pit_accu_cnt_m3` is highly correlated with `pit_income_cnt_m3`	High correlation
`seg_flight` is highly correlated with `seg_route_to`	High correlation
`seg_route_to` is highly correlated with `seg_flight`	High correlation
`pit_add_buy_cnt_y2` is highly correlated with `pit_add_buy_amt_y1` and 1 other fields	High correlation
`pit_add_buy_amt_y1` is highly correlated with `pit_add_buy_cnt_y2` and 1 other fields	High correlation
`pit_add_buy_cnt_y3` is highly correlated with `pit_add_buy_amt_y1` and 1 other fields	High correlation
`pit_income_cnt_m3` is highly correlated with `pit_accu_cnt_m3`	High correlation
`pit_accu_cnt_m3` is highly correlated with `pit_income_cnt_m3`	High correlation
`pax_name` is uniformly distributed	Uniform
`pax_passport` is uniformly distributed	Uniform

Reproduction

Analysis started	2021-02-23 07:41:51.994604
Analysis finished	2021-02-23 07:45:04.931227
Duration	3 minutes and 12.94 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

pax_name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	20972
Distinct (%)	89.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

1c86fb42ab58cb2df206bae2b6ed15a1	33
8e2fb4de629808f9429cb279c85d7efc	15
b592ca6e8d0518ddab5eeb89f5a0449f	14
d4ab2ef44db402186d29d15fb438cbbf	10
646fc2fcc29979f51696a66049db024b	10
Other values (20967)	23350

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1c86fb42ab58cb2df206bae2b6ed15a1	33	0.1%
8e2fb4de629808f9429cb279c85d7efc	15	0.1%
b592ca6e8d0518ddab5eeb89f5a0449f	14	0.1%
d4ab2ef44db402186d29d15fb438cbbf	10	< 0.1%
646fc2fcc29979f51696a66049db024b	10	< 0.1%
d527ea7035d967f33cd32046db343813	10	< 0.1%
a1f1c4cf158e388bbc4648bf7917b3fb	9	< 0.1%
bf0b48b96aad1ec7f6f1a5c043d18f3b	9	< 0.1%
1ee68ac7d269936eac3cb678535c1667	8	< 0.1%
382aa316f27ef8038d9c4b3959ce63f3	8	< 0.1%
Other values (20962)	23306	99.5%

Frequencies of value counts

Unique

Unique	19244 ?
Unique (%)	82.1%

Histogram of lengths of the category

Length

Max length	32
Median length	32
Mean length	32
Min length	32

pax_passport
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	21075
Distinct (%)	89.9%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

306536af81b052feefee3ad9cb168da8	30
b19ea5fe19a2a9551b65f09a3b8e8a70	15
18a6a516c905d041ca3545d9a43d1d14	14
1ccd17e3c86face6f81bc2efdfc33831	12
21c328427fa457a489bb520fb7c12b81	10
Other values (21070)	23351

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
306536af81b052feefee3ad9cb168da8	30	0.1%
b19ea5fe19a2a9551b65f09a3b8e8a70	15	0.1%
18a6a516c905d041ca3545d9a43d1d14	14	0.1%
1ccd17e3c86face6f81bc2efdfc33831	12	0.1%
21c328427fa457a489bb520fb7c12b81	10	< 0.1%
717635ba93bd3823db106f96e9d033c3	9	< 0.1%
96cfa9c2e5984debcf67f8bc2a8333da	9	< 0.1%
70e00017a5076f46784e2e24a103d441	9	< 0.1%
50853ec77def2dba80246c5c0464456a	8	< 0.1%
5d71151bbbd856f3d76fa09059f8e68f	8	< 0.1%
Other values (21065)	23308	99.5%

Frequencies of value counts

Unique

Unique	19376 ?
Unique (%)	82.7%

Histogram of lengths of the category

Length

Max length	32
Median length	32
Mean length	32
Min length	32

seg_route_to
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

LAX	7910
JFK	7894
SYD	7628

Frequencies
Length

Value	Count	Frequency (%)
LAX	7910	33.8%
JFK	7894	33.7%
SYD	7628	32.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

seg_flight
Categorical

HIGH CORRELATION

Distinct	17
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

AB1007	4902
AB1006	4568
AB1008	4228
AB1010	3326
AB1009	2968
Other values (12)	3440

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
AB1007	4902	20.9%
AB1006	4568	19.5%
AB1008	4228	18.0%
AB1010	3326	14.2%
AB1009	2968	12.7%
AB1013	2565	10.9%
AB1015	686	2.9%
AB1014	160	0.7%
AB1005	14	0.1%
AB1000	5	< 0.1%
Other values (7)	10	< 0.1%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	6
Median length	6
Mean length	6
Min length	6

seg_cabin
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	183.1 KiB

Y	20363
J	2962
W	90
F	12
C	4

Frequencies
Length

Value	Count	Frequency (%)
Y	20363	86.9%
J	2962	12.6%
W	90	0.4%
F	12	0.1%
C	4	< 0.1%
(Missing)	1	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.000085353
Min length	1

seg_dep_time
Categorical

HIGH CARDINALITY

Distinct	5655
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

2018/12/24 0:05	46
2018/12/23 20:20	34
2019/12/31 0:05	30
2019/1/12 20:20	30
2019/4/24 20:20	29
Other values (5650)	23263

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2018/12/24 0:05	46	0.2%
2018/12/23 20:20	34	0.1%
2019/12/31 0:05	30	0.1%
2019/1/12 20:20	30	0.1%
2019/4/24 20:20	29	0.1%
2019/1/2 20:20	29	0.1%
2018/4/11 21:00	28	0.1%
2019/3/24 13:20	28	0.1%
2018/12/29 20:20	28	0.1%
2019/4/26 20:20	26	0.1%
Other values (5645)	23124	98.7%

Frequencies of value counts

Unique

Unique	1315 ?
Unique (%)	5.6%

Histogram of lengths of the category

Length

Max length	16
Median length	15
Mean length	14.88199898
Min length	13

pax_fcny
Real number (ℝ_≥0)

Distinct	3153
Distinct (%)	13.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22285.2966
Minimum	0
Maximum	4264300
Zeros	34
Zeros (%)	0.1%
Memory size	183.1 KiB

Quantile statistics

Minimum	0
5-th percentile	150
Q1	317.75
median	568
Q3	1196
95-th percentile	63769
Maximum	4264300
Range	4264300
Interquartile range (IQR)	878.25

Descriptive statistics

Standard deviation	117848.6986
Coefficient of variation (CV)	5.28818174
Kurtosis	237.1807462
Mean	22285.2966
Median Absolute Deviation (MAD)	312
Skewness	11.36753735
Sum	522189069.9
Variance	1.388831575e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	391	1.7%
300	346	1.5%
150	252	1.1%
220	237	1.0%
160	221	0.9%
250	182	0.8%
240	161	0.7%
210	160	0.7%
230	149	0.6%
280	135	0.6%
Other values (3143)	21198	90.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	0.1%
0.05	16	0.1%
0.1	1	< 0.1%
14	1	< 0.1%
16	1	< 0.1%

Value	Count	Frequency (%)
4264300	1	< 0.1%
3544600	1	< 0.1%
3465100	1	< 0.1%
3198200	2	< 0.1%
2800000	2	< 0.1%

pax_tax
Real number (ℝ_≥0)

Distinct	5409
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15419.39163
Minimum	0
Maximum	636700
Zeros	90
Zeros (%)	0.4%
Memory size	183.1 KiB

Quantile statistics

Minimum	0
5-th percentile	150.86
Q1	242.525
median	299.36
Q3	454.06
95-th percentile	30730
Maximum	636700
Range	636700
Interquartile range (IQR)	211.535

Descriptive statistics

Standard deviation	69443.02403
Coefficient of variation (CV)	4.503616335
Kurtosis	20.07018201
Mean	15419.39163
Median Absolute Deviation (MAD)	127.9
Skewness	4.65651811
Sum	361307184.7
Variance	4822333586
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
454.16	256	1.1%
455.61	179	0.8%
454.43	174	0.7%
454.06	164	0.7%
454.26	153	0.7%
455.51	149	0.6%
299.06	144	0.6%
280.46	129	0.6%
455.43	121	0.5%
152.86	118	0.5%
Other values (5399)	21845	93.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	90	0.4%
0.05	16	0.1%
0.1	1	< 0.1%
5.6	1	< 0.1%
10.6	3	< 0.1%

Value	Count	Frequency (%)
636700	1	< 0.1%
494900	1	< 0.1%
484900	1	< 0.1%
399300	1	< 0.1%
397500	1	< 0.1%

emd_lable
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	16230
1	7202

Common Values
Chart

Value	Count	Frequency (%)
0	16230	69.3%
1	7202	30.7%

emd_lable2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21957
1	1475

Common Values
Chart

Value	Count	Frequency (%)
0	21957	93.7%
1	1475	6.3%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	18629
M	2432
F	2313
U	58

Frequencies
Length

Value	Count	Frequency (%)
0	18629	79.5%
M	2432	10.4%
F	2313	9.9%
U	58	0.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

age
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19464
21-30	1226
31-40	923
51-60	604
41-50	550
Other values (3)	665

Frequencies
Length

Value	Count	Frequency (%)
0	19464	83.1%
21-30	1226	5.2%
31-40	923	3.9%
51-60	604	2.6%
41-50	550	2.3%
60+	523	2.2%
11月20日	108	0.5%
0-10	34	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	6
Median length	1
Mean length	1.635882554
Min length	1

birth_date
Categorical

HIGH CARDINALITY

Distinct	2915
Distinct (%)	12.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19833
1966/4/22	15
1967/10/30	14
1959/9/14	8
1984/5/7	6
Other values (2910)	3556

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19833	84.6%
1966/4/22	15	0.1%
1967/10/30	14	0.1%
1959/9/14	8	< 0.1%
1984/5/7	6	< 0.1%
1986/4/18	6	< 0.1%
1988/9/26	5	< 0.1%
1966/11/9	5	< 0.1%
1963/9/8	5	< 0.1%
1959/4/3	5	< 0.1%
Other values (2905)	3530	15.1%

Frequencies of value counts

Unique

Unique	2407 ?
Unique (%)	10.3%

Histogram of lengths of the category

Length

Max length	10
Median length	1
Mean length	2.223967224
Min length	1

residence_country
Categorical

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19023
中国	4290
美国	66
澳大利亚	24
日本	5
Other values (10)	24

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19023	81.2%
中国	4290	18.3%
美国	66	0.3%
澳大利亚	24	0.1%
日本	5	< 0.1%
中国台湾	5	< 0.1%
新加坡	4	< 0.1%
泰国	3	< 0.1%
越南	3	< 0.1%
英国	3	< 0.1%
Other values (5)	6	< 0.1%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.190935473
Min length	1

nation_name
Categorical

HIGH CARDINALITY

Distinct	56
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19887
美国	1577
中国	932
澳大利亚	399
韩国	233
Other values (51)	404

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19887	84.9%
美国	1577	6.7%
中国	932	4.0%
澳大利亚	399	1.7%
韩国	233	1.0%
菲律宾	68	0.3%
中国台湾	46	0.2%
新加坡	41	0.2%
日本	30	0.1%
墨西哥	29	0.1%
Other values (46)	190	0.8%

Frequencies of value counts

Unique

Unique	19 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	8
Median length	1
Mean length	1.203354387
Min length	1

city_name
Categorical

HIGH CARDINALITY

Distinct	298
Distinct (%)	1.3%
Missing	4
Missing (%)	< 0.1%
Memory size	183.1 KiB

0	22438
上海市	179
上海	154
***	46
浦东新区	19
Other values (293)	592

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22438	95.8%
上海市	179	0.8%
上海	154	0.7%
***	46	0.2%
浦东新区	19	0.1%
北京	18	0.1%
Sydney	17	0.1%
悉尼	12	0.1%
长宁区	12	0.1%
苏州	10	< 0.1%
Other values (288)	523	2.2%

Frequencies of value counts

Unique

Unique	187 ?
Unique (%)	0.8%

Histogram of lengths of the category

Length

Max length	17
Median length	1
Mean length	1.121073745
Min length	1

province_name
Categorical

HIGH CARDINALITY

Distinct	88
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22496
SH	389
JS	91
ZJ	46
NSW	43
Other values (83)	367

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22496	96.0%
SH	389	1.7%
JS	91	0.4%
ZJ	46	0.2%
NSW	43	0.2%
AH	42	0.2%
BJ	26	0.1%
SD	24	0.1%
***	20	0.1%
CA	16	0.1%
Other values (78)	239	1.0%

Frequencies of value counts

Unique

Unique	40 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	15
Median length	1
Mean length	1.060131444
Min length	1

marital_stat
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22840
U	309
S	195
M	88

Frequencies
Length

Value	Count	Frequency (%)
0	22840	97.5%
U	309	1.3%
S	195	0.8%
M	88	0.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

member_level
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19833
STD	3263
SILHL	145
GOLHL	75
PLTSL	73
Other values (2)	43

Frequencies
Length

Value	Count	Frequency (%)
0	19833	84.6%
STD	3263	13.9%
SILHL	145	0.6%
GOLHL	75	0.3%
PLTSL	73	0.3%
CHD	39	0.2%
SILSL	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.332536702
Min length	1

enroll_chnl
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19833
网站	3052
销售单位	175
手机平台	136
其它	118
Other values (3)	118

Frequencies
Length

Value	Count	Frequency (%)
0	19833	84.6%
网站	3052	13.0%
销售单位	175	0.7%
手机平台	136	0.6%
其它	118	0.5%
电话	66	0.3%
移动客舱	51	0.2%
联名卡	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.184533971
Min length	1

cabin_hf_cnt_m3
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23415
2	10
1	7

Frequencies
Length

Value	Count	Frequency (%)
0	23415	99.9%
2	10	< 0.1%
1	7	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

cabin_hf_cnt_m6
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23408
1	13
2	11

Frequencies
Length

Value	Count	Frequency (%)
0	23408	99.9%
1	13	0.1%
2	11	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

cabin_hf_cnt_y1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23393
1	24
2	13
3	2

Frequencies
Length

Value	Count	Frequency (%)
0	23393	99.8%
1	24	0.1%
2	13	0.1%
3	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

cabin_f_cnt_m3
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23430
2	1
1	1

Frequencies
Length

Value	Count	Frequency (%)
0	23430	> 99.9%
2	1	< 0.1%
1	1	< 0.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

cabin_f_cnt_m6
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23421
1	7
2	4

Frequencies
Length

Value	Count	Frequency (%)
0	23421	> 99.9%
1	7	< 0.1%
2	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pref_aircraft_m3_1
Categorical

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22495
773	362
359	167
789	88
33H	45
Other values (20)	275

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22495	96.0%
773	362	1.5%
359	167	0.7%
789	88	0.4%
33H	45	0.2%
73H	40	0.2%
33E	33	0.1%
33L	31	0.1%
320	29	0.1%
325	25	0.1%
Other values (15)	117	0.5%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.079976101
Min length	1

pref_aircraft_m3_2
Categorical

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22495
773	226
359	159
320	70
33H	53
Other values (19)	429

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22495	96.0%
773	226	1.0%
359	159	0.7%
320	70	0.3%
33H	53	0.2%
325	49	0.2%
73H	49	0.2%
789	49	0.2%
33E	48	0.2%
738	42	0.2%
Other values (14)	192	0.8%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.079976101
Min length	1

pref_aircraft_m3_3
Categorical

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22730
773	203
359	141
325	43
33H	43
Other values (18)	272

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22730	97.0%
773	203	0.9%
359	141	0.6%
325	43	0.2%
33H	43	0.2%
789	37	0.2%
320	36	0.2%
33L	33	0.1%
73H	24	0.1%
33E	23	0.1%
Other values (13)	119	0.5%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.059918061
Min length	1

pref_aircraft_m3_4
Categorical

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22825
773	202
359	131
320	42
789	34
Other values (18)	198

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22825	97.4%
773	202	0.9%
359	131	0.6%
320	42	0.2%
789	34	0.1%
33H	31	0.1%
33E	25	0.1%
73H	21	0.1%
325	20	0.1%
738	17	0.1%
Other values (13)	84	0.4%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.051809491
Min length	1

pref_aircraft_m3_5
Categorical

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22870
773	202
359	126
789	34
33H	32
Other values (18)	168

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22870	97.6%
773	202	0.9%
359	126	0.5%
789	34	0.1%
33H	32	0.1%
320	26	0.1%
325	21	0.1%
73H	21	0.1%
33E	15	0.1%
738	15	0.1%
Other values (13)	70	0.3%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.04796859
Min length	1

pref_aircraft_m6_1
Categorical

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21882
773	669
359	303
789	107
33H	79
Other values (20)	392

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21882	93.4%
773	669	2.9%
359	303	1.3%
789	107	0.5%
33H	79	0.3%
320	64	0.3%
73H	50	0.2%
33L	48	0.2%
73E	42	0.2%
325	37	0.2%
Other values (15)	151	0.6%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.132297713
Min length	1

pref_aircraft_m6_2
Categorical

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21882
773	392
359	264
33H	113
320	112
Other values (21)	669

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21882	93.4%
773	392	1.7%
359	264	1.1%
33H	113	0.5%
320	112	0.5%
33E	81	0.3%
33L	80	0.3%
325	77	0.3%
73H	64	0.3%
789	60	0.3%
Other values (16)	307	1.3%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.132297713
Min length	1

pref_aircraft_m6_3
Categorical

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22274
773	350
359	236
33H	83
320	74
Other values (17)	415

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22274	95.1%
773	350	1.5%
359	236	1.0%
33H	83	0.4%
320	74	0.3%
325	69	0.3%
73H	48	0.2%
33E	45	0.2%
789	38	0.2%
33L	35	0.1%
Other values (12)	180	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.098839194
Min length	1

pref_aircraft_m6_4
Categorical

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22457
773	343
359	223
320	65
33H	56
Other values (18)	288

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22457	95.8%
773	343	1.5%
359	223	1.0%
320	65	0.3%
33H	56	0.2%
325	53	0.2%
789	37	0.2%
33E	33	0.1%
73E	31	0.1%
738	25	0.1%
Other values (13)	109	0.5%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.083219529
Min length	1

pref_aircraft_m6_5
Categorical

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22537
773	342
359	219
33H	54
320	47
Other values (17)	233

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22537	96.2%
773	342	1.5%
359	219	0.9%
33H	54	0.2%
320	47	0.2%
789	37	0.2%
325	29	0.1%
33E	27	0.1%
73E	19	0.1%
33L	19	0.1%
Other values (12)	102	0.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.07639126
Min length	1

pref_aircraft_y1_1
Categorical

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20327
773	1752
359	356
33H	247
789	122
Other values (19)	628

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20327	86.7%
773	1752	7.5%
359	356	1.5%
33H	247	1.1%
789	122	0.5%
33L	97	0.4%
320	83	0.4%
325	73	0.3%
73H	67	0.3%
33E	63	0.3%
Other values (14)	245	1.0%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.265022192
Min length	1

pref_aircraft_y1_2
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20327
773	837
33H	315
359	266
33L	221
Other values (23)	1466

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20327	86.7%
773	837	3.6%
33H	315	1.3%
359	266	1.1%
33L	221	0.9%
320	190	0.8%
73H	186	0.8%
33E	181	0.8%
325	157	0.7%
73E	113	0.5%
Other values (18)	639	2.7%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.265022192
Min length	1

pref_aircraft_y1_3
Categorical

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21175
773	718
33H	265
359	197
33E	154
Other values (21)	923

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21175	90.4%
773	718	3.1%
33H	265	1.1%
359	197	0.8%
33E	154	0.7%
325	136	0.6%
320	133	0.6%
33L	121	0.5%
73H	70	0.3%
738	67	0.3%
Other values (16)	396	1.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.19264254
Min length	1

pref_aircraft_y1_4
Categorical

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21711
773	698
359	166
33H	158
320	111
Other values (20)	588

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21711	92.7%
773	698	3.0%
359	166	0.7%
33H	158	0.7%
320	111	0.5%
325	96	0.4%
33E	96	0.4%
33L	56	0.2%
73E	42	0.2%
73H	38	0.2%
Other values (15)	260	1.1%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.146893138
Min length	1

pref_aircraft_y1_5
Categorical

Distinct	25
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21959
773	688
359	160
33H	127
33E	91
Other values (20)	407

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21959	93.7%
773	688	2.9%
359	160	0.7%
33H	127	0.5%
33E	91	0.4%
325	61	0.3%
33L	47	0.2%
320	47	0.2%
73H	42	0.2%
73E	28	0.1%
Other values (15)	182	0.8%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.125725504
Min length	1

pref_aircraft_y2_1
Categorical

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15962
773	5397
33H	919
320	185
33E	164
Other values (22)	805

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15962	68.1%
773	5397	23.0%
33H	919	3.9%
320	185	0.8%
33E	164	0.7%
359	127	0.5%
73H	124	0.5%
325	106	0.5%
33L	90	0.4%
73E	69	0.3%
Other values (17)	289	1.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.637589621
Min length	1

pref_aircraft_y2_2
Categorical

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15962
773	1892
73H	811
33H	732
325	698
Other values (24)	3337

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15962	68.1%
773	1892	8.1%
73H	811	3.5%
33H	732	3.1%
325	698	3.0%
33L	548	2.3%
320	526	2.2%
33E	505	2.2%
73E	270	1.2%
73L	217	0.9%
Other values (19)	1271	5.4%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.637589621
Min length	1

pref_aircraft_y2_3
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	18224
773	1545
33H	487
320	470
33E	452
Other values (23)	2254

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	18224	77.8%
773	1545	6.6%
33H	487	2.1%
320	470	2.0%
33E	452	1.9%
325	406	1.7%
73H	209	0.9%
73E	204	0.9%
323	203	0.9%
33L	200	0.9%
Other values (18)	1032	4.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.444520314
Min length	1

pref_aircraft_y2_4
Categorical

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20187
773	1448
33H	269
33E	265
325	203
Other values (22)	1060

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20187	86.2%
773	1448	6.2%
33H	269	1.1%
33E	265	1.1%
325	203	0.9%
320	191	0.8%
73H	109	0.5%
73E	97	0.4%
33L	91	0.4%
333	77	0.3%
Other values (17)	495	2.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.276971663
Min length	1

pref_aircraft_y2_5
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20851
773	1430
33H	221
33E	148
320	147
Other values (23)	635

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20851	89.0%
773	1430	6.1%
33H	221	0.9%
33E	148	0.6%
320	147	0.6%
325	106	0.5%
73H	75	0.3%
33L	59	0.3%
73E	51	0.2%
321	51	0.2%
Other values (18)	293	1.3%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.22029703
Min length	1

pref_aircraft_y3_1
Categorical

Distinct	26
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
773	6900
33H	1010
320	267
33E	201
Other values (21)	878

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
773	6900	29.4%
33H	1010	4.3%
320	267	1.1%
33E	201	0.9%
73H	192	0.8%
325	154	0.7%
359	91	0.4%
33L	86	0.4%
73E	64	0.3%
Other values (16)	291	1.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.790030727
Min length	1

pref_aircraft_y3_2
Categorical

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
773	2303
73H	1193
325	957
33H	800
Other values (24)	4003

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
773	2303	9.8%
73H	1193	5.1%
325	957	4.1%
33H	800	3.4%
320	704	3.0%
33E	640	2.7%
33L	612	2.6%
73E	315	1.3%
738	236	1.0%
Other values (19)	1496	6.4%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.790030727
Min length	1

pref_aircraft_y3_3
Categorical

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17013
773	1806
320	614
33E	553
33H	540
Other values (25)	2906

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17013	72.6%
773	1806	7.7%
320	614	2.6%
33E	553	2.4%
33H	540	2.3%
325	490	2.1%
73H	326	1.4%
73E	276	1.2%
323	261	1.1%
33L	254	1.1%
Other values (20)	1299	5.5%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.547883237
Min length	1

pref_aircraft_y3_4
Categorical

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19455
773	1688
33E	305
33H	286
325	278
Other values (23)	1420

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19455	83.0%
773	1688	7.2%
33E	305	1.3%
33H	286	1.2%
325	278	1.2%
320	253	1.1%
73E	149	0.6%
73H	143	0.6%
33L	127	0.5%
323	100	0.4%
Other values (18)	648	2.8%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.339450324
Min length	1

pref_aircraft_y3_5
Categorical

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20312
773	1659
33H	224
320	201
33E	173
Other values (22)	863

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20312	86.7%
773	1659	7.1%
33H	224	1.0%
320	201	0.9%
33E	173	0.7%
325	133	0.6%
73H	102	0.4%
33L	84	0.4%
738	60	0.3%
323	59	0.3%
Other values (17)	425	1.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.266302492
Min length	1

prebuy_i_cnt_m3_d3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23381
1	37
2	13
5	1

Frequencies
Length

Value	Count	Frequency (%)
0	23381	99.8%
1	37	0.2%
2	13	0.1%
5	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

prebuy_i_cnt_m3_d7
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23364
1	61
2	6
4	1

Frequencies
Length

Value	Count	Frequency (%)
0	23364	99.7%
1	61	0.3%
2	6	< 0.1%
4	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

prebuy_i_cnt_m3_d30
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23269
1	132
2	25
3	6

Frequencies
Length

Value	Count	Frequency (%)
0	23269	99.3%
1	132	0.6%
2	25	0.1%
3	6	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pref_orig_m3_1
Categorical

HIGH CARDINALITY

Distinct	63
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22658
PVG	354
SYD	117
SHA	72
JFK	51
Other values (58)	180

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22658	96.7%
PVG	354	1.5%
SYD	117	0.5%
SHA	72	0.3%
JFK	51	0.2%
LAX	24	0.1%
PEK	16	0.1%
TSA	11	< 0.1%
XIY	10	< 0.1%
TAO	10	< 0.1%
Other values (53)	109	0.5%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.066063503
Min length	1

pref_orig_m3_2
Categorical

HIGH CARDINALITY

Distinct	84
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22658
PVG	190
SYD	130
JFK	101
LAX	58
Other values (79)	295

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22658	96.7%
PVG	190	0.8%
SYD	130	0.6%
JFK	101	0.4%
LAX	58	0.2%
SHA	39	0.2%
PEK	27	0.1%
ICN	17	0.1%
CKG	11	< 0.1%
BKK	10	< 0.1%
Other values (74)	191	0.8%

Frequencies of value counts

Unique

Unique	28 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.066063503
Min length	1

pref_orig_m3_3
Categorical

HIGH CARDINALITY

Distinct	68
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22893
PVG	141
SYD	79
JFK	60
KIX	34
Other values (63)	225

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22893	97.7%
PVG	141	0.6%
SYD	79	0.3%
JFK	60	0.3%
KIX	34	0.1%
LAX	32	0.1%
SHA	21	0.1%
PEK	17	0.1%
ICN	8	< 0.1%
HKG	7	< 0.1%
Other values (58)	140	0.6%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.046005463
Min length	1

pref_orig_m3_4
Categorical

HIGH CARDINALITY

Distinct	56
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22998
PVG	124
SYD	75
JFK	54
LAX	30
Other values (51)	151

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22998	98.1%
PVG	124	0.5%
SYD	75	0.3%
JFK	54	0.2%
LAX	30	0.1%
CDG	29	0.1%
SHA	15	0.1%
PEK	12	0.1%
SZX	6	< 0.1%
CTU	5	< 0.1%
Other values (46)	84	0.4%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.03704336
Min length	1

pref_orig_m3_5
Categorical

HIGH CARDINALITY

Distinct	51
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23057
PVG	123
SYD	75
JFK	50
LAX	25
Other values (46)	102

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	23057	98.4%
PVG	123	0.5%
SYD	75	0.3%
JFK	50	0.2%
LAX	25	0.1%
SHA	15	0.1%
PEK	12	0.1%
KWE	5	< 0.1%
CAN	5	< 0.1%
KHN	4	< 0.1%
Other values (41)	61	0.3%

Frequencies of value counts

Unique

Unique	28 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.032007511
Min length	1

pref_orig_m6_1
Categorical

HIGH CARDINALITY

Distinct	73
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22164
PVG	574
SYD	205
SHA	99
JFK	96
Other values (68)	294

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22164	94.6%
PVG	574	2.4%
SYD	205	0.9%
SHA	99	0.4%
JFK	96	0.4%
LAX	29	0.1%
PEK	24	0.1%
TSA	17	0.1%
WUH	16	0.1%
SZX	15	0.1%
Other values (63)	193	0.8%

Frequencies of value counts

Unique

Unique	30 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.108228064
Min length	1

pref_orig_m6_2
Categorical

HIGH CARDINALITY

Distinct	100
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22164
PVG	332
JFK	187
SYD	182
LAX	98
Other values (95)	469

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22164	94.6%
PVG	332	1.4%
JFK	187	0.8%
SYD	182	0.8%
LAX	98	0.4%
SHA	63	0.3%
PEK	52	0.2%
ICN	24	0.1%
KMG	21	0.1%
BKK	15	0.1%
Other values (90)	294	1.3%

Frequencies of value counts

Unique

Unique	31 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.108228064
Min length	1

pref_orig_m6_3
Categorical

HIGH CARDINALITY

Distinct	89
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22576
PVG	191
JFK	123
SYD	106
LAX	53
Other values (84)	383

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22576	96.3%
PVG	191	0.8%
JFK	123	0.5%
SYD	106	0.5%
LAX	53	0.2%
KIX	35	0.1%
PEK	34	0.1%
SHA	34	0.1%
KMG	13	0.1%
XIY	12	0.1%
Other values (79)	255	1.1%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.073062479
Min length	1

pref_orig_m6_4
Categorical

HIGH CARDINALITY

Distinct	80
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22771
PVG	164
JFK	106
SYD	100
LAX	32
Other values (75)	259

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22771	97.2%
PVG	164	0.7%
JFK	106	0.5%
SYD	100	0.4%
LAX	32	0.1%
CNX	29	0.1%
SHA	21	0.1%
PEK	21	0.1%
KMG	13	0.1%
ICN	11	< 0.1%
Other values (70)	164	0.7%

Frequencies of value counts

Unique

Unique	32 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.056418573
Min length	1

pref_orig_m6_5
Categorical

HIGH CARDINALITY

Distinct	67
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22850
PVG	159
SYD	97
JFK	93
LAX	30
Other values (62)	203

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22850	97.5%
PVG	159	0.7%
SYD	97	0.4%
JFK	93	0.4%
LAX	30	0.1%
CDG	29	0.1%
PEK	21	0.1%
SHA	15	0.1%
WUH	8	< 0.1%
KMG	7	< 0.1%
Other values (57)	123	0.5%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.049675657
Min length	1

pref_orig_y1_1
Categorical

HIGH CARDINALITY

Distinct	80
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20870
PVG	1444
SYD	428
SHA	130
JFK	101
Other values (75)	459

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20870	89.1%
PVG	1444	6.2%
SYD	428	1.8%
SHA	130	0.6%
JFK	101	0.4%
PEK	37	0.2%
LAX	33	0.1%
TSA	27	0.1%
TAO	27	0.1%
XIY	23	0.1%
Other values (70)	312	1.3%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.218675316
Min length	1

pref_orig_y1_2
Categorical

HIGH CARDINALITY

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20870
PVG	648
JFK	412
SYD	309
LAX	239
Other values (111)	954

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20870	89.1%
PVG	648	2.8%
JFK	412	1.8%
SYD	309	1.3%
LAX	239	1.0%
SHA	102	0.4%
ICN	65	0.3%
PEK	59	0.3%
MNL	37	0.2%
KMG	31	0.1%
Other values (106)	660	2.8%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.218675316
Min length	1

pref_orig_y1_3
Categorical

HIGH CARDINALITY

Distinct	118
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21808
PVG	283
JFK	224
SYD	161
LAX	140
Other values (113)	816

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21808	93.1%
PVG	283	1.2%
JFK	224	1.0%
SYD	161	0.7%
LAX	140	0.6%
SHA	74	0.3%
PEK	74	0.3%
CDG	52	0.2%
BKK	36	0.2%
HKG	27	0.1%
Other values (108)	553	2.4%

Frequencies of value counts

Unique

Unique	33 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.138613861
Min length	1

pref_orig_y1_4
Categorical

HIGH CARDINALITY

Distinct	94
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22424
PVG	221
SYD	120
JFK	100
LAX	60
Other values (89)	507

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22424	95.7%
PVG	221	0.9%
SYD	120	0.5%
JFK	100	0.4%
LAX	60	0.3%
SHA	45	0.2%
PEK	31	0.1%
MLE	29	0.1%
HKG	22	0.1%
ICN	22	0.1%
Other values (84)	358	1.5%

Frequencies of value counts

Unique

Unique	26 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.08603619
Min length	1

pref_orig_y1_5
Categorical

HIGH CARDINALITY

Distinct	87
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22593
PVG	204
SYD	117
JFK	86
KIX	35
Other values (82)	397

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22593	96.4%
PVG	204	0.9%
SYD	117	0.5%
JFK	86	0.4%
KIX	35	0.1%
LAX	31	0.1%
PEK	30	0.1%
SHA	22	0.1%
KMG	16	0.1%
SZX	14	0.1%
Other values (77)	284	1.2%

Frequencies of value counts

Unique

Unique	26 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.071611471
Min length	1

pref_orig_y2_1
Categorical

HIGH CARDINALITY

Distinct	79
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17007
PVG	4653
SYD	849
SHA	195
JFK	162
Other values (74)	566

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17007	72.6%
PVG	4653	19.9%
SYD	849	3.6%
SHA	195	0.8%
JFK	162	0.7%
LAX	69	0.3%
XIY	41	0.2%
WUH	39	0.2%
TSA	34	0.1%
TAO	30	0.1%
Other values (69)	353	1.5%

Frequencies of value counts

Unique

Unique	22 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.548395357
Min length	1

pref_orig_y2_2
Categorical

HIGH CARDINALITY

Distinct	131
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17007
JFK	1451
PVG	1243
LAX	1163
SYD	775
Other values (126)	1793

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17007	72.6%
JFK	1451	6.2%
PVG	1243	5.3%
LAX	1163	5.0%
SYD	775	3.3%
SHA	174	0.7%
SIN	100	0.4%
MNL	93	0.4%
PEK	91	0.4%
PUS	61	0.3%
Other values (121)	1274	5.4%

Frequencies of value counts

Unique

Unique	31 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.548395357
Min length	1

pref_orig_y2_3
Categorical

HIGH CARDINALITY

Distinct	134
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19138
JFK	650
LAX	540
ICN	336
PVG	327
Other values (129)	2441

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19138	81.7%
JFK	650	2.8%
LAX	540	2.3%
ICN	336	1.4%
PVG	327	1.4%
BKK	305	1.3%
SYD	208	0.9%
SHA	163	0.7%
PEK	122	0.5%
HKG	91	0.4%
Other values (124)	1552	6.6%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.36650734
Min length	1

pref_orig_y2_4
Categorical

HIGH CARDINALITY

Distinct	120
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21866
PVG	192
JFK	188
LAX	126
SHA	114
Other values (115)	946

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21866	93.3%
PVG	192	0.8%
JFK	188	0.8%
LAX	126	0.5%
SHA	114	0.5%
SYD	100	0.4%
PEK	75	0.3%
ICN	46	0.2%
HKG	41	0.2%
KMG	36	0.2%
Other values (110)	648	2.8%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.133663366
Min length	1

pref_orig_y2_5
Categorical

HIGH CARDINALITY

Distinct	102
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22423
PVG	163
JFK	117
SYD	78
LAX	66
Other values (97)	585

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22423	95.7%
PVG	163	0.7%
JFK	117	0.5%
SYD	78	0.3%
LAX	66	0.3%
PEK	46	0.2%
SIN	41	0.2%
SHA	38	0.2%
HKG	29	0.1%
KMG	23	0.1%
Other values (92)	408	1.7%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.086121543
Min length	1

pref_orig_y3_1
Categorical

HIGH CARDINALITY

Distinct	73
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15619
PVG	5974
SYD	883
SHA	211
JFK	191
Other values (68)	554

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15619	66.7%
PVG	5974	25.5%
SYD	883	3.8%
SHA	211	0.9%
JFK	191	0.8%
LAX	72	0.3%
WUH	38	0.2%
XIY	35	0.1%
TSA	35	0.1%
TPE	32	0.1%
Other values (63)	342	1.5%

Frequencies of value counts

Unique

Unique	21 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.666865825
Min length	1

pref_orig_y3_2
Categorical

HIGH CARDINALITY

Distinct	130
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15619
JFK	1771
LAX	1545
PVG	1325
SYD	822
Other values (125)	2350

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15619	66.7%
JFK	1771	7.6%
LAX	1545	6.6%
PVG	1325	5.7%
SYD	822	3.5%
SHA	191	0.8%
SIN	158	0.7%
MNL	150	0.6%
PEK	120	0.5%
BKK	91	0.4%
Other values (120)	1640	7.0%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.666865825
Min length	1

pref_orig_y3_3
Categorical

HIGH CARDINALITY

Distinct	141
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	18050
JFK	810
LAX	756
BKK	422
ICN	396
Other values (136)	2998

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	18050	77.0%
JFK	810	3.5%
LAX	756	3.2%
BKK	422	1.8%
ICN	396	1.7%
PVG	309	1.3%
SHA	231	1.0%
SYD	204	0.9%
PEK	135	0.6%
HKG	120	0.5%
Other values (131)	1999	8.5%

Frequencies of value counts

Unique

Unique	22 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.459371799
Min length	1

pref_orig_y3_4
Categorical

HIGH CARDINALITY

Distinct	132
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21527
JFK	245
LAX	164
PVG	145
SHA	140
Other values (127)	1211

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21527	91.9%
JFK	245	1.0%
LAX	164	0.7%
PVG	145	0.6%
SHA	140	0.6%
PEK	110	0.5%
SYD	78	0.3%
HKG	63	0.3%
KMG	58	0.2%
ICN	53	0.2%
Other values (122)	849	3.6%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.162598156
Min length	1

pref_orig_y3_5
Categorical

HIGH CARDINALITY

Distinct	108
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22323
JFK	130
PVG	115
LAX	72
PEK	59
Other values (103)	733

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22323	95.3%
JFK	130	0.6%
PVG	115	0.5%
LAX	72	0.3%
PEK	59	0.3%
SHA	56	0.2%
SYD	56	0.2%
HKG	39	0.2%
KMG	36	0.2%
YVR	30	0.1%
Other values (98)	516	2.2%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.094656879
Min length	1

pref_line_m3_1
Categorical

HIGH CARDINALITY

Distinct	176
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22658
SYD-PVG	158
PVG-SYD	70
JFK-PVG	62
PVG-JFK	55
Other values (171)	429

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22658	96.7%
SYD-PVG	158	0.7%
PVG-SYD	70	0.3%
JFK-PVG	62	0.3%
PVG-JFK	55	0.2%
PVG-LAX	34	0.1%
LAX-PVG	34	0.1%
SHA-PEK	17	0.1%
PVG-BKK	16	0.1%
PVG-ICN	14	0.1%
Other values (166)	314	1.3%

Frequencies of value counts

Unique

Unique	93 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.198190509
Min length	1

pref_line_m3_2
Categorical

HIGH CARDINALITY

Distinct	195
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22658
PVG-JFK	90
PVG-SYD	90
SYD-PVG	63
PVG-LAX	49
Other values (190)	482

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22658	96.7%
PVG-JFK	90	0.4%
PVG-SYD	90	0.4%
SYD-PVG	63	0.3%
PVG-LAX	49	0.2%
JFK-PVG	36	0.2%
KIX-PVG	35	0.1%
LAX-PVG	29	0.1%
PEK-SHA	16	0.1%
SHA-PEK	14	0.1%
Other values (185)	352	1.5%

Frequencies of value counts

Unique

Unique	109 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.198190509
Min length	1

pref_line_m3_3
Categorical

HIGH CARDINALITY

Distinct	155
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22872
PVG-SYD	79
SYD-PVG	62
PVG-JFK	57
CDG-PVG	30
Other values (150)	332

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22872	97.6%
PVG-SYD	79	0.3%
SYD-PVG	62	0.3%
PVG-JFK	57	0.2%
CDG-PVG	30	0.1%
PVG-LAX	29	0.1%
JFK-PVG	28	0.1%
LAX-PVG	12	0.1%
PVG-CKG	10	< 0.1%
SHA-PEK	10	< 0.1%
Other values (145)	243	1.0%

Frequencies of value counts

Unique

Unique	92 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.14339365
Min length	1

pref_line_m3_4
Categorical

HIGH CARDINALITY

Distinct	140
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22941
PVG-SYD	68
SYD-PVG	62
PVG-JFK	61
PVG-KIX	31
Other values (135)	269

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22941	97.9%
PVG-SYD	68	0.3%
SYD-PVG	62	0.3%
PVG-JFK	61	0.3%
PVG-KIX	31	0.1%
PVG-LAX	25	0.1%
JFK-PVG	23	0.1%
PEK-SHA	11	< 0.1%
LAX-PVG	10	< 0.1%
SHA-PEK	10	< 0.1%
Other values (130)	190	0.8%

Frequencies of value counts

Unique

Unique	94 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.125725504
Min length	1

pref_line_m3_5
Categorical

HIGH CARDINALITY

Distinct	108
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23010
PVG-SYD	92
SYD-PVG	62
PVG-JFK	52
JFK-PVG	23
Other values (103)	193

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	23010	98.2%
PVG-SYD	92	0.4%
SYD-PVG	62	0.3%
PVG-JFK	52	0.2%
JFK-PVG	23	0.1%
PVG-LAX	23	0.1%
LAX-PVG	13	0.1%
PEK-SHA	8	< 0.1%
SHA-PEK	8	< 0.1%
KMG-SYD	5	< 0.1%
Other values (98)	136	0.6%

Frequencies of value counts

Unique

Unique	73 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.108057357
Min length	1

pref_line_m6_1
Categorical

HIGH CARDINALITY

Distinct	219
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22164
SYD-PVG	229
JFK-PVG	135
PVG-JFK	111
PVG-SYD	107
Other values (214)	686

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22164	94.6%
SYD-PVG	229	1.0%
JFK-PVG	135	0.6%
PVG-JFK	111	0.5%
PVG-SYD	107	0.5%
LAX-PVG	72	0.3%
PVG-LAX	51	0.2%
SHA-PEK	24	0.1%
PVG-BKK	22	0.1%
PVG-ICN	20	0.1%
Other values (209)	497	2.1%

Frequencies of value counts

Unique

Unique	105 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.324684193
Min length	1

pref_line_m6_2
Categorical

HIGH CARDINALITY

Distinct	269
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22164
PVG-SYD	181
PVG-JFK	162
PVG-LAX	90
JFK-PVG	88
Other values (264)	747

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22164	94.6%
PVG-SYD	181	0.8%
PVG-JFK	162	0.7%
PVG-LAX	90	0.4%
JFK-PVG	88	0.4%
SYD-PVG	76	0.3%
LAX-PVG	33	0.1%
BKK-PVG	20	0.1%
SHA-PEK	19	0.1%
PVG-ICN	19	0.1%
Other values (259)	580	2.5%

Frequencies of value counts

Unique

Unique	132 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.324684193
Min length	1

pref_line_m6_3
Categorical

HIGH CARDINALITY

Distinct	224
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22546
PVG-JFK	115
PVG-SYD	114
SYD-PVG	67
JFK-PVG	53
Other values (219)	537

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22546	96.2%
PVG-JFK	115	0.5%
PVG-SYD	114	0.5%
SYD-PVG	67	0.3%
JFK-PVG	53	0.2%
PVG-LAX	38	0.2%
CNX-PVG	30	0.1%
LAX-PVG	18	0.1%
PVG-CKG	10	< 0.1%
XIY-PVG	10	< 0.1%
Other values (214)	431	1.8%

Frequencies of value counts

Unique

Unique	115 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.226869239
Min length	1

pref_line_m6_4
Categorical

HIGH CARDINALITY

Distinct	198
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22661
PVG-JFK	115
PVG-SYD	99
SYD-PVG	67
JFK-PVG	42
Other values (193)	448

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22661	96.7%
PVG-JFK	115	0.5%
PVG-SYD	99	0.4%
SYD-PVG	67	0.3%
JFK-PVG	42	0.2%
KIX-PVG	39	0.2%
PVG-LAX	30	0.1%
PEK-SHA	12	0.1%
ICN-PVG	11	< 0.1%
SHA-PEK	10	< 0.1%
Other values (188)	346	1.5%

Frequencies of value counts

Unique

Unique	105 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.197422328
Min length	1

pref_line_m6_5
Categorical

HIGH CARDINALITY

Distinct	161
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22803
PVG-JFK	97
PVG-SYD	85
SYD-PVG	67
JFK-PVG	42
Other values (156)	338

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22803	97.3%
PVG-JFK	97	0.4%
PVG-SYD	85	0.4%
SYD-PVG	67	0.3%
JFK-PVG	42	0.2%
CDG-PVG	30	0.1%
PVG-LAX	25	0.1%
ICN-PVG	11	< 0.1%
SHA-PEK	9	< 0.1%
PVG-TSA	8	< 0.1%
Other values (151)	255	1.1%

Frequencies of value counts

Unique

Unique	91 ?
Unique (%)	0.4%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.161061796
Min length	1

pref_line_y1_1
Categorical

HIGH CARDINALITY

Distinct	282
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20870
SYD-PVG	477
JFK-PVG	425
LAX-PVG	245
PVG-SYD	187
Other values (277)	1228

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20870	89.1%
SYD-PVG	477	2.0%
JFK-PVG	425	1.8%
LAX-PVG	245	1.0%
PVG-SYD	187	0.8%
PVG-JFK	143	0.6%
PVG-LAX	76	0.3%
PVG-BKK	53	0.2%
PVG-ICN	51	0.2%
SIN-PVG	37	0.2%
Other values (272)	868	3.7%

Frequencies of value counts

Unique

Unique	132 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.656025947
Min length	1

pref_line_y1_2
Categorical

HIGH CARDINALITY

Distinct	334
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20870
PVG-SYD	356
PVG-JFK	334
PVG-LAX	218
JFK-PVG	206
Other values (329)	1448

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20870	89.1%
PVG-SYD	356	1.5%
PVG-JFK	334	1.4%
PVG-LAX	218	0.9%
JFK-PVG	206	0.9%
LAX-PVG	142	0.6%
SYD-PVG	125	0.5%
PVG-ICN	38	0.2%
PVG-HKG	31	0.1%
PEK-SHA	28	0.1%
Other values (324)	1084	4.6%

Frequencies of value counts

Unique

Unique	129 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.656025947
Min length	1

pref_line_y1_3
Categorical

HIGH CARDINALITY

Distinct	306
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21751
PVG-SYD	179
PVG-JFK	176
PVG-LAX	129
JFK-PVG	108
Other values (301)	1089

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21751	92.8%
PVG-SYD	179	0.8%
PVG-JFK	176	0.8%
PVG-LAX	129	0.6%
JFK-PVG	108	0.5%
SYD-PVG	79	0.3%
LAX-PVG	38	0.2%
CDG-PVG	30	0.1%
PVG-TSN	21	0.1%
WNZ-PVG	19	0.1%
Other values (296)	902	3.8%

Frequencies of value counts

Unique

Unique	133 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.430437009
Min length	1

pref_line_y1_4
Categorical

HIGH CARDINALITY

Distinct	288
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21961
PVG-JFK	164
PVG-SYD	157
JFK-PVG	89
SYD-PVG	75
Other values (283)	986

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21961	93.7%
PVG-JFK	164	0.7%
PVG-SYD	157	0.7%
JFK-PVG	89	0.4%
SYD-PVG	75	0.3%
PVG-CDG	43	0.2%
PVG-LAX	36	0.2%
BKK-PVG	30	0.1%
LAX-PVG	30	0.1%
ICN-PVG	28	0.1%
Other values (278)	819	3.5%

Frequencies of value counts

Unique

Unique	131 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.376664391
Min length	1

pref_line_y1_5
Categorical

HIGH CARDINALITY

Distinct	242
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22470
PVG-SYD	119
PVG-JFK	92
JFK-PVG	72
SYD-PVG	70
Other values (237)	609

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22470	95.9%
PVG-SYD	119	0.5%
PVG-JFK	92	0.4%
JFK-PVG	72	0.3%
SYD-PVG	70	0.3%
PVG-LAX	35	0.1%
CNX-PVG	30	0.1%
LAX-PVG	19	0.1%
SHA-PEK	14	0.1%
PVG-CDG	12	0.1%
Other values (232)	499	2.1%

Frequencies of value counts

Unique

Unique	126 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.246329805
Min length	1

pref_line_y2_1
Categorical

HIGH CARDINALITY

Distinct	322
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17007
JFK-PVG	1214
SYD-PVG	1182
LAX-PVG	764
PVG-BKK	318
Other values (317)	2947

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17007	72.6%
JFK-PVG	1214	5.2%
SYD-PVG	1182	5.0%
LAX-PVG	764	3.3%
PVG-BKK	318	1.4%
PVG-JFK	307	1.3%
PVG-LAX	302	1.3%
PVG-SYD	300	1.3%
PVG-ICN	297	1.3%
SIN-PVG	117	0.5%
Other values (312)	1624	6.9%

Frequencies of value counts

Unique

Unique	138 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.64518607
Min length	1

pref_line_y2_2
Categorical

HIGH CARDINALITY

Distinct	377
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17007
PVG-JFK	945
PVG-SYD	757
PVG-LAX	744
JFK-PVG	737
Other values (372)	3242

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17007	72.6%
PVG-JFK	945	4.0%
PVG-SYD	757	3.2%
PVG-LAX	744	3.2%
JFK-PVG	737	3.1%
LAX-PVG	708	3.0%
SYD-PVG	223	1.0%
PVG-ICN	100	0.4%
BKK-PVG	96	0.4%
ICN-PVG	53	0.2%
Other values (367)	2062	8.8%

Frequencies of value counts

Unique

Unique	134 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.64518607
Min length	1

pref_line_y2_3
Categorical

HIGH CARDINALITY

Distinct	411
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19001
PVG-LAX	695
PVG-JFK	641
PVG-SYD	394
LAX-PVG	138
Other values (406)	2563

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19001	81.1%
PVG-LAX	695	3.0%
PVG-JFK	641	2.7%
PVG-SYD	394	1.7%
LAX-PVG	138	0.6%
JFK-PVG	132	0.6%
SYD-PVG	77	0.3%
PVG-KUL	70	0.3%
PVG-SHE	50	0.2%
HKG-PVG	50	0.2%
Other values (401)	2184	9.3%

Frequencies of value counts

Unique

Unique	150 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.134602253
Min length	1

pref_line_y2_4
Categorical

HIGH CARDINALITY

Distinct	390
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	19448
PVG-JFK	491
ICN-PVG	340
PVG-SYD	328
BKK-PVG	286
Other values (385)	2539

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	19448	83.0%
PVG-JFK	491	2.1%
ICN-PVG	340	1.5%
PVG-SYD	328	1.4%
BKK-PVG	286	1.2%
PVG-LAX	129	0.6%
JFK-PVG	85	0.4%
LAX-PVG	81	0.3%
HKT-PVG	78	0.3%
NRT-PVG	74	0.3%
Other values (380)	2092	8.9%

Frequencies of value counts

Unique

Unique	151 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.020143394
Min length	1

pref_line_y2_5
Categorical

HIGH CARDINALITY

Distinct	348
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22004
PVG-JFK	131
PVG-SYD	113
PVG-LAX	83
JFK-PVG	56
Other values (343)	1045

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22004	93.9%
PVG-JFK	131	0.6%
PVG-SYD	113	0.5%
PVG-LAX	83	0.4%
JFK-PVG	56	0.2%
LAX-PVG	43	0.2%
SYD-PVG	42	0.2%
PVG-CDG	34	0.1%
PVG-HKG	24	0.1%
BKK-PVG	22	0.1%
Other values (338)	880	3.8%

Frequencies of value counts

Unique

Unique	164 ?
Unique (%)	0.7%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.365653807
Min length	1

pref_line_y3_1
Categorical

HIGH CARDINALITY

Distinct	312
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15619
JFK-PVG	1539
SYD-PVG	1231
LAX-PVG	1078
PVG-BKK	484
Other values (307)	3481

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15619	66.7%
JFK-PVG	1539	6.6%
SYD-PVG	1231	5.3%
LAX-PVG	1078	4.6%
PVG-BKK	484	2.1%
PVG-ICN	378	1.6%
PVG-LAX	341	1.5%
PVG-SYD	338	1.4%
PVG-JFK	329	1.4%
SIN-PVG	179	0.8%
Other values (302)	1916	8.2%

Frequencies of value counts

Unique

Unique	114 ?
Unique (%)	0.5%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	3.000597474
Min length	1

pref_line_y3_2
Categorical

HIGH CARDINALITY

Distinct	379
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15619
PVG-JFK	1131
PVG-LAX	1028
LAX-PVG	1014
JFK-PVG	929
Other values (374)	3711

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15619	66.7%
PVG-JFK	1131	4.8%
PVG-LAX	1028	4.4%
LAX-PVG	1014	4.3%
JFK-PVG	929	4.0%
PVG-SYD	780	3.3%
SYD-PVG	283	1.2%
PVG-ICN	110	0.5%
BKK-PVG	92	0.4%
PVG-HKG	74	0.3%
Other values (369)	2372	10.1%

Frequencies of value counts

Unique

Unique	145 ?
Unique (%)	0.6%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	3.000597474
Min length	1

pref_line_y3_3
Categorical

HIGH CARDINALITY

Distinct	442
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17768
PVG-LAX	937
PVG-JFK	805
PVG-SYD	383
LAX-PVG	170
Other values (437)	3369

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17768	75.8%
PVG-LAX	937	4.0%
PVG-JFK	805	3.4%
PVG-SYD	383	1.6%
LAX-PVG	170	0.7%
JFK-PVG	143	0.6%
SYD-PVG	88	0.4%
HKG-PVG	83	0.4%
PVG-KUL	81	0.3%
MNL-PVG	69	0.3%
Other values (432)	2905	12.4%

Frequencies of value counts

Unique

Unique	156 ?
Unique (%)	0.7%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.450324343
Min length	1

pref_line_y3_4
Categorical

HIGH CARDINALITY

Distinct	435
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	18457
PVG-JFK	624
ICN-PVG	401
BKK-PVG	395
PVG-SYD	324
Other values (430)	3231

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	18457	78.8%
PVG-JFK	624	2.7%
ICN-PVG	401	1.7%
BKK-PVG	395	1.7%
PVG-SYD	324	1.4%
PVG-LAX	191	0.8%
PVG-SIN	116	0.5%
HKT-PVG	97	0.4%
JFK-PVG	92	0.4%
LAX-PVG	91	0.4%
Other values (425)	2644	11.3%

Frequencies of value counts

Unique

Unique	164 ?
Unique (%)	0.7%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	2.273898942
Min length	1

pref_line_y3_5
Categorical

HIGH CARDINALITY

Distinct	394
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21679
PVG-JFK	154
PVG-LAX	101
PVG-SYD	99
LAX-PVG	79
Other values (389)	1320

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21679	92.5%
PVG-JFK	154	0.7%
PVG-LAX	101	0.4%
PVG-SYD	99	0.4%
LAX-PVG	79	0.3%
JFK-PVG	37	0.2%
SYD-PVG	33	0.1%
BKK-PVG	26	0.1%
PVG-SIN	23	0.1%
HKG-PVG	22	0.1%
Other values (384)	1179	5.0%

Frequencies of value counts

Unique

Unique	170 ?
Unique (%)	0.7%

Histogram of lengths of the category

Length

Max length	7
Median length	1
Mean length	1.448873336
Min length	1

pref_city_m3_1
Categorical

HIGH CARDINALITY

Distinct	61
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22495
PVG	451
SYD	149
SHA	66
JFK	49
Other values (56)	222

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22495	96.0%
PVG	451	1.9%
SYD	149	0.6%
SHA	66	0.3%
JFK	49	0.2%
LAX	27	0.1%
TSA	12	0.1%
SZX	11	< 0.1%
NKG	11	< 0.1%
WUH	11	< 0.1%
Other values (51)	150	0.6%

Frequencies of value counts

Unique

Unique	18 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.079976101
Min length	1

pref_city_m3_2
Categorical

HIGH CARDINALITY

Distinct	84
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22495
PVG	287
JFK	126
SYD	121
LAX	75
Other values (79)	328

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22495	96.0%
PVG	287	1.2%
JFK	126	0.5%
SYD	121	0.5%
LAX	75	0.3%
SHA	37	0.2%
SIN	16	0.1%
KMG	16	0.1%
PEK	16	0.1%
ICN	14	0.1%
Other values (74)	229	1.0%

Frequencies of value counts

Unique

Unique	18 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.079976101
Min length	1

pref_city_m3_3
Categorical

HIGH CARDINALITY

Distinct	68
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22804
PVG	210
SYD	84
JFK	58
LAX	37
Other values (63)	239

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22804	97.3%
PVG	210	0.9%
SYD	84	0.4%
JFK	58	0.2%
LAX	37	0.2%
SHA	25	0.1%
PEK	13	0.1%
ICN	13	0.1%
CTU	11	< 0.1%
KMG	11	< 0.1%
Other values (58)	166	0.7%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.053601912
Min length	1

pref_city_m3_4
Categorical

HIGH CARDINALITY

Distinct	56
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22927
PVG	189
SYD	78
JFK	52
LAX	30
Other values (51)	156

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22927	97.8%
PVG	189	0.8%
SYD	78	0.3%
JFK	52	0.2%
LAX	30	0.1%
SHA	15	0.1%
HKG	8	< 0.1%
SZX	7	< 0.1%
CTU	7	< 0.1%
NKG	7	< 0.1%
Other values (46)	112	0.5%

Frequencies of value counts

Unique

Unique	16 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.043103448
Min length	1

pref_city_m3_5
Categorical

Distinct	50
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22969
PVG	189
SYD	78
JFK	47
LAX	27
Other values (45)	122

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22969	98.0%
PVG	189	0.8%
SYD	78	0.3%
JFK	47	0.2%
LAX	27	0.1%
SHA	13	0.1%
NKG	8	< 0.1%
CAN	6	< 0.1%
CTU	5	< 0.1%
ICN	4	< 0.1%
Other values (40)	86	0.4%

Frequencies of value counts

Unique

Unique	16 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.039518607
Min length	1

pref_city_m6_1
Categorical

HIGH CARDINALITY

Distinct	76
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21882
PVG	726
SYD	279
SHA	91
JFK	88
Other values (71)	366

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21882	93.4%
PVG	726	3.1%
SYD	279	1.2%
SHA	91	0.4%
JFK	88	0.4%
LAX	56	0.2%
WUH	19	0.1%
XIY	18	0.1%
SZX	17	0.1%
NKG	17	0.1%
Other values (66)	239	1.0%

Frequencies of value counts

Unique

Unique	26 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.132297713
Min length	1

pref_city_m6_2
Categorical

HIGH CARDINALITY

Distinct	103
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21882
PVG	473
JFK	217
SYD	186
LAX	140
Other values (98)	534

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21882	93.4%
PVG	473	2.0%
JFK	217	0.9%
SYD	186	0.8%
LAX	140	0.6%
SHA	62	0.3%
PEK	31	0.1%
KMG	29	0.1%
NKG	22	0.1%
ICN	22	0.1%
Other values (93)	368	1.6%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.132297713
Min length	1

pref_city_m6_3
Categorical

HIGH CARDINALITY

Distinct	89
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22426
PVG	268
JFK	133
SYD	127
LAX	83
Other values (84)	395

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22426	95.7%
PVG	268	1.1%
JFK	133	0.6%
SYD	127	0.5%
LAX	83	0.4%
SHA	32	0.1%
PEK	25	0.1%
HKG	21	0.1%
CAN	14	0.1%
KMG	14	0.1%
Other values (79)	289	1.2%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.085865483
Min length	1

pref_city_m6_4
Categorical

HIGH CARDINALITY

Distinct	74
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22663
PVG	235
SYD	112
JFK	98
LAX	56
Other values (69)	268

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22663	96.7%
PVG	235	1.0%
SYD	112	0.5%
JFK	98	0.4%
LAX	56	0.2%
SHA	25	0.1%
CAN	18	0.1%
KMG	14	0.1%
PEK	11	< 0.1%
NKG	11	< 0.1%
Other values (64)	189	0.8%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.065636736
Min length	1

pref_city_m6_5
Categorical

HIGH CARDINALITY

Distinct	64
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22753
PVG	229
SYD	108
JFK	88
LAX	54
Other values (59)	200

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22753	97.1%
PVG	229	1.0%
SYD	108	0.5%
JFK	88	0.4%
LAX	54	0.2%
SHA	27	0.1%
NKG	11	< 0.1%
PEK	10	< 0.1%
CAN	8	< 0.1%
KMG	7	< 0.1%
Other values (54)	137	0.6%

Frequencies of value counts

Unique

Unique	19 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.057954933
Min length	1

pref_city_y1_1
Categorical

HIGH CARDINALITY

Distinct	92
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20327
PVG	1816
SYD	509
SHA	126
JFK	91
Other values (87)	563

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20327	86.7%
PVG	1816	7.8%
SYD	509	2.2%
SHA	126	0.5%
JFK	91	0.4%
LAX	41	0.2%
TSA	40	0.2%
XIY	35	0.1%
WUH	28	0.1%
TAO	24	0.1%
Other values (82)	395	1.7%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.265022192
Min length	1

pref_city_y1_2
Categorical

HIGH CARDINALITY

Distinct	123
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20327
PVG	830
JFK	512
SYD	342
LAX	325
Other values (118)	1096

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20327	86.7%
PVG	830	3.5%
JFK	512	2.2%
SYD	342	1.5%
LAX	325	1.4%
SHA	102	0.4%
ICN	78	0.3%
PEK	60	0.3%
NKG	42	0.2%
KMG	41	0.2%
Other values (113)	773	3.3%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.265022192
Min length	1

pref_city_y1_3
Categorical

HIGH CARDINALITY

Distinct	119
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21501
PVG	330
JFK	289
LAX	165
SYD	155
Other values (114)	992

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21501	91.8%
PVG	330	1.4%
JFK	289	1.2%
LAX	165	0.7%
SYD	155	0.7%
SHA	87	0.4%
ICN	63	0.3%
BKK	44	0.2%
PEK	41	0.2%
KMG	40	0.2%
Other values (109)	717	3.1%

Frequencies of value counts

Unique

Unique	26 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.164817344
Min length	1

pref_city_y1_4
Categorical

HIGH CARDINALITY

Distinct	107
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22334
PVG	268
SYD	113
JFK	108
SHA	61
Other values (102)	548

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22334	95.3%
PVG	268	1.1%
SYD	113	0.5%
JFK	108	0.5%
SHA	61	0.3%
LAX	44	0.2%
PEK	41	0.2%
ICN	35	0.1%
KMG	30	0.1%
NKG	22	0.1%
Other values (97)	376	1.6%

Frequencies of value counts

Unique

Unique	37 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.093717992
Min length	1

pref_city_y1_5
Categorical

HIGH CARDINALITY

Distinct	98
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22548
PVG	254
SYD	104
JFK	93
SHA	39
Other values (93)	394

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22548	96.2%
PVG	254	1.1%
SYD	104	0.4%
JFK	93	0.4%
SHA	39	0.2%
CAN	25	0.1%
LAX	24	0.1%
ICN	21	0.1%
PEK	20	0.1%
KMG	15	0.1%
Other values (88)	289	1.2%

Frequencies of value counts

Unique

Unique	31 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.075452373
Min length	1

pref_city_y2_1
Categorical

HIGH CARDINALITY

Distinct	85
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15962
PVG	5472
SYD	944
SHA	219
JFK	214
Other values (80)	621

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15962	68.1%
PVG	5472	23.4%
SYD	944	4.0%
SHA	219	0.9%
JFK	214	0.9%
LAX	94	0.4%
XIY	47	0.2%
TPE	38	0.2%
WUH	37	0.2%
TSA	37	0.2%
Other values (75)	368	1.6%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.637589621
Min length	1

pref_city_y2_2
Categorical

HIGH CARDINALITY

Distinct	127
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15962
JFK	1738
PVG	1412
LAX	1335
SYD	933
Other values (122)	2052

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15962	68.1%
JFK	1738	7.4%
PVG	1412	6.0%
LAX	1335	5.7%
SYD	933	4.0%
SHA	191	0.8%
SIN	123	0.5%
PEK	92	0.4%
PUS	87	0.4%
MNL	81	0.3%
Other values (117)	1478	6.3%

Frequencies of value counts

Unique

Unique	22 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.637589621
Min length	1

pref_city_y2_3
Categorical

HIGH CARDINALITY

Distinct	141
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	18473
JFK	765
LAX	578
PVG	412
ICN	377
Other values (136)	2827

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	18473	78.8%
JFK	765	3.3%
LAX	578	2.5%
PVG	412	1.8%
ICN	377	1.6%
BKK	287	1.2%
SYD	239	1.0%
SHA	204	0.9%
PEK	121	0.5%
HKG	115	0.5%
Other values (131)	1861	7.9%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.423267327
Min length	1

pref_city_y2_4
Categorical

HIGH CARDINALITY

Distinct	132
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21595
PVG	232
JFK	213
LAX	128
SHA	124
Other values (127)	1140

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21595	92.2%
PVG	232	1.0%
JFK	213	0.9%
LAX	128	0.5%
SHA	124	0.5%
SYD	99	0.4%
PEK	75	0.3%
KMG	61	0.3%
ICN	56	0.2%
BKK	45	0.2%
Other values (122)	804	3.4%

Frequencies of value counts

Unique

Unique	30 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.156794128
Min length	1

pref_city_y2_5
Categorical

HIGH CARDINALITY

Distinct	107
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22306
PVG	194
JFK	154
SYD	82
LAX	55
Other values (102)	641

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22306	95.2%
PVG	194	0.8%
JFK	154	0.7%
SYD	82	0.3%
LAX	55	0.2%
KMG	43	0.2%
HND	41	0.2%
PEK	36	0.2%
SHA	35	0.1%
NKG	28	0.1%
Other values (97)	458	2.0%

Frequencies of value counts

Unique

Unique	21 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.096107887
Min length	1

pref_city_y3_1
Categorical

HIGH CARDINALITY

Distinct	78
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
PVG	7169
SYD	978
JFK	247
SHA	228
Other values (73)	634

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
PVG	7169	30.6%
SYD	978	4.2%
JFK	247	1.1%
SHA	228	1.0%
LAX	93	0.4%
WUH	49	0.2%
TSA	49	0.2%
XIY	41	0.2%
TPE	39	0.2%
Other values (68)	363	1.5%

Frequencies of value counts

Unique

Unique	29 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.790030727
Min length	1

pref_city_y3_2
Categorical

HIGH CARDINALITY

Distinct	130
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
JFK	2207
LAX	1820
PVG	1500
SYD	985
Other values (125)	2744

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
JFK	2207	9.4%
LAX	1820	7.8%
PVG	1500	6.4%
SYD	985	4.2%
SHA	213	0.9%
SIN	186	0.8%
MNL	145	0.6%
PEK	111	0.5%
NRT	108	0.5%
Other values (120)	1981	8.5%

Frequencies of value counts

Unique

Unique	18 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.790030727
Min length	1

pref_city_y3_3
Categorical

HIGH CARDINALITY

Distinct	149
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17094
JFK	981
LAX	842
ICN	448
BKK	441
Other values (144)	3626

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17094	73.0%
JFK	981	4.2%
LAX	842	3.6%
ICN	448	1.9%
BKK	441	1.9%
PVG	367	1.6%
SHA	281	1.2%
SYD	254	1.1%
HKG	157	0.7%
PEK	153	0.7%
Other values (139)	2414	10.3%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.540969614
Min length	1

pref_city_y3_4
Categorical

HIGH CARDINALITY

Distinct	146
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21197
JFK	256
PVG	195
LAX	168
SHA	156
Other values (141)	1460

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21197	90.5%
JFK	256	1.1%
PVG	195	0.8%
LAX	168	0.7%
SHA	156	0.7%
PEK	99	0.4%
SYD	82	0.3%
KMG	77	0.3%
ICN	66	0.3%
NKG	65	0.3%
Other values (136)	1071	4.6%

Frequencies of value counts

Unique

Unique	36 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.190764766
Min length	1

pref_city_y3_5
Categorical

HIGH CARDINALITY

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22124
JFK	173
PVG	136
LAX	89
PEK	60
Other values (111)	850

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22124	94.4%
JFK	173	0.7%
PVG	136	0.6%
LAX	89	0.4%
PEK	60	0.3%
SYD	58	0.2%
KMG	55	0.2%
HND	54	0.2%
SHA	50	0.2%
BKK	47	0.2%
Other values (106)	586	2.5%

Frequencies of value counts

Unique

Unique	28 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.111642199
Min length	1

recent_flt_day
Categorical

HIGH CARDINALITY

Distinct	994
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
2019/1/5	56
2019/1/1	43
2019/1/6	43
2020/1/5	40
Other values (989)	9074

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
2019/1/5	56	0.2%
2019/1/1	43	0.2%
2019/1/6	43	0.2%
2020/1/5	40	0.2%
2019/1/11	38	0.2%
2019/1/4	36	0.2%
2020/1/17	34	0.1%
2019/8/21	34	0.1%
2018/4/2	34	0.1%
Other values (984)	8898	38.0%

Frequencies of value counts

Unique

Unique	55 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	10
Median length	1
Mean length	4.142113349
Min length	1

bag_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23415
1	17

Common Values
Chart

Value	Count	Frequency (%)
0	23415	99.9%
1	17	0.1%

bag_cnt_m6
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23406
1	25
2	1

Frequencies
Length

Value	Count	Frequency (%)
0	23406	99.9%
1	25	0.1%
2	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

bag_cnt_y1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23373
1	56
2	2
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	23373	99.7%
1	56	0.2%
2	2	< 0.1%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

select_seat_cnt_y1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23332
1	65
2	22
3	13

Frequencies
Length

Value	Count	Frequency (%)
0	23332	99.6%
1	65	0.3%
2	22	0.1%
3	13	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

flt_cancel_cnt_y3
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23421
1	10
2	1

Frequencies
Length

Value	Count	Frequency (%)
0	23421	> 99.9%
1	10	< 0.1%
2	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

flt_delay_cnt_m3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23301
1	112
2	18
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	23301	99.4%
1	112	0.5%
2	18	0.1%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pref_orig_city_m3
Categorical

HIGH CARDINALITY

Distinct	76
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22495
Shanghai	347
SYDNEY	145
New York	107
Los Angeles	53
Other values (71)	285

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22495	96.0%
Shanghai	347	1.5%
SYDNEY	145	0.6%
New York	107	0.5%
Los Angeles	53	0.2%
Kunming	19	0.1%
Beijing	17	0.1%
Seoul	17	0.1%
Hangzhou	15	0.1%
Wuhan	13	0.1%
Other values (66)	204	0.9%

Frequencies of value counts

Unique

Unique	23 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	1
Mean length	1.267241379
Min length	1

pref_orig_city_m6
Categorical

HIGH CARDINALITY

Distinct	90
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21882
Shanghai	638
SYDNEY	234
New York	171
Los Angeles	79
Other values (85)	428

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	21882	93.4%
Shanghai	638	2.7%
SYDNEY	234	1.0%
New York	171	0.7%
Los Angeles	79	0.3%
Beijing	31	0.1%
BANGKOK	26	0.1%
Kunming	25	0.1%
Wuhan	24	0.1%
Hangzhou	23	0.1%
Other values (80)	299	1.3%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	26
Median length	1
Mean length	1.443111984
Min length	1

pref_orig_city_y1
Categorical

HIGH CARDINALITY

Distinct	102
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20327
Shanghai	1442
New York	437
SYDNEY	372
Los Angeles	213
Other values (97)	641

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20327	86.7%
Shanghai	1442	6.2%
New York	437	1.9%
SYDNEY	372	1.6%
Los Angeles	213	0.9%
Beijing	48	0.2%
Wuhan	37	0.2%
Nanjing	35	0.1%
Kunming	34	0.1%
Hong Kong-Hlpt	31	0.1%
Other values (92)	456	1.9%

Frequencies of value counts

Unique

Unique	25 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	26
Median length	1
Mean length	1.916311028
Min length	1

pref_orig_city_y2
Categorical

HIGH CARDINALITY

Distinct	104
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15962
Shanghai	4406
New York	907
SYDNEY	650
Los Angeles	494
Other values (99)	1013

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15962	68.1%
Shanghai	4406	18.8%
New York	907	3.9%
SYDNEY	650	2.8%
Los Angeles	494	2.1%
BANGKOK	82	0.3%
Beijing	65	0.3%
Seoul	61	0.3%
Hong Kong-Hlpt	46	0.2%
Kunming	37	0.2%
Other values (94)	722	3.1%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	26
Median length	1
Mean length	3.233142711
Min length	1

pref_orig_city_y3
Categorical

HIGH CARDINALITY

Distinct	102
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	14176
Shanghai	5783
New York	1052
Los Angeles	720
SYDNEY	651
Other values (97)	1050

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	14176	60.5%
Shanghai	5783	24.7%
New York	1052	4.5%
Los Angeles	720	3.1%
SYDNEY	651	2.8%
BANGKOK	91	0.4%
Beijing	68	0.3%
Seoul	52	0.2%
Hong Kong-Hlpt	52	0.2%
Kunming	45	0.2%
Other values (92)	742	3.2%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	23
Median length	1
Mean length	3.790926938
Min length	1

pref_dest_city_m3
Categorical

HIGH CARDINALITY

Distinct	77
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22658
Shanghai	288
SYDNEY	106
New York	94
Los Angeles	56
Other values (72)	230

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22658	96.7%
Shanghai	288	1.2%
SYDNEY	106	0.5%
New York	94	0.4%
Los Angeles	56	0.2%
Beijing	27	0.1%
Guangzhou	9	< 0.1%
BANGKOK	9	< 0.1%
Xi'an	9	< 0.1%
Qingdao	8	< 0.1%
Other values (67)	168	0.7%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	1.225674292
Min length	1

pref_dest_city_m6
Categorical

HIGH CARDINALITY

Distinct	90
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22165
Shanghai	458
SYDNEY	171
New York	163
Los Angeles	93
Other values (85)	382

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	22165	94.6%
Shanghai	458	2.0%
SYDNEY	171	0.7%
New York	163	0.7%
Los Angeles	93	0.4%
Beijing	40	0.2%
TAIPEI	19	0.1%
Kunming	18	0.1%
BANGKOK	14	0.1%
Hangzhou	14	0.1%
Other values (80)	277	1.2%

Frequencies of value counts

Unique

Unique	28 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	20
Median length	1
Mean length	1.367488904
Min length	1

pref_dest_city_y1
Categorical

HIGH CARDINALITY

Distinct	94
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20873
Shanghai	1068
SYDNEY	373
New York	336
Los Angeles	144
Other values (89)	638

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	20873	89.1%
Shanghai	1068	4.6%
SYDNEY	373	1.6%
New York	336	1.4%
Los Angeles	144	0.6%
Seoul	49	0.2%
Beijing	47	0.2%
TAIPEI	37	0.2%
Kunming	30	0.1%
Nanjing	21	0.1%
Other values (84)	454	1.9%

Frequencies of value counts

Unique

Unique	18 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	1.735703312
Min length	1

pref_dest_city_y2
Categorical

HIGH CARDINALITY

Distinct	95
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	17010
Shanghai	3584
New York	924
SYDNEY	718
Los Angeles	517
Other values (90)	679

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	17010	72.6%
Shanghai	3584	15.3%
New York	924	3.9%
SYDNEY	718	3.1%
Los Angeles	517	2.2%
Beijing	48	0.2%
TAIPEI	44	0.2%
Wuhan	35	0.1%
Kunming	35	0.1%
BANGKOK	33	0.1%
Other values (85)	484	2.1%

Frequencies of value counts

Unique

Unique	24 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	20
Median length	1
Mean length	2.906794128
Min length	1

pref_dest_city_y3
Categorical

HIGH CARDINALITY

Distinct	89
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	15622
Shanghai	4721
New York	993
SYDNEY	737
Los Angeles	642
Other values (84)	717

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	15622	66.7%
Shanghai	4721	20.1%
New York	993	4.2%
SYDNEY	737	3.1%
Los Angeles	642	2.7%
BANGKOK	52	0.2%
Beijing	51	0.2%
TAIPEI	46	0.2%
Seoul	40	0.2%
Kunming	39	0.2%
Other values (79)	489	2.1%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	22
Median length	1
Mean length	3.33757255
Min length	1

cabin_fall_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	23431	> 99.9%
1	1	< 0.1%

cabin_fall_cnt_m6
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23430
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	23430	> 99.9%
1	2	< 0.1%

cabin_fall_cnt_y1
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23430
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	23430	> 99.9%
1	2	< 0.1%

cabin_fall_cnt_y2
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23428
1	4

Common Values
Chart

Value	Count	Frequency (%)
0	23428	> 99.9%
1	4	< 0.1%

cabin_fall_cnt_y3
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23415
1	15
2	2

Frequencies
Length

Value	Count	Frequency (%)
0	23415	99.9%
1	15	0.1%
2	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

tkt_return_cnt_m3
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23423
2	5
1	4

Frequencies
Length

Value	Count	Frequency (%)
0	23423	> 99.9%
2	5	< 0.1%
1	4	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

tkt_return_all_cnt_m3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23420
1	8
2	3
3	1

Frequencies
Length

Value	Count	Frequency (%)
0	23420	99.9%
1	8	< 0.1%
2	3	< 0.1%
3	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_accu_cnt_m3
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23300
1	93
2	33
3	6

Frequencies
Length

Value	Count	Frequency (%)
0	23300	99.4%
1	93	0.4%
2	33	0.1%
3	6	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_cons_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23411
1	21

Common Values
Chart

Value	Count	Frequency (%)
0	23411	99.9%
1	21	0.1%

pit_add_buy_amt_y1
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
1700	1

Frequencies
Length

Value	Count	Frequency (%)
0	23431	> 99.9%
1700	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.00012803
Min length	1

pit_des_upg_amt_m3
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
25000	1

Frequencies
Length

Value	Count	Frequency (%)
0	23431	> 99.9%
25000	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.000170707
Min length	1

pit_add_air_cnt_m3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23339
1	71
2	19
3	3

Frequencies
Length

Value	Count	Frequency (%)
0	23339	99.6%
1	71	0.3%
2	19	0.1%
3	3	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_add_non_cnt_m3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23411
1	19
4	1
2	1

Frequencies
Length

Value	Count	Frequency (%)
0	23411	99.9%
1	19	0.1%
4	1	< 0.1%
2	1	< 0.1%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_add_buy_cnt_y1
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	23431	> 99.9%
1	1	< 0.1%

pit_add_buy_cnt_y2
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23424
1	7
2	1

Frequencies
Length

Value	Count	Frequency (%)
0	23424	> 99.9%
1	7	< 0.1%
2	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_add_buy_cnt_y3
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23422
1	9
2	1

Frequencies
Length

Value	Count	Frequency (%)
0	23422	> 99.9%
1	9	< 0.1%
2	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_des_upg_cnt_m3
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	23431	> 99.9%
1	1	< 0.1%

pit_des_upg_cnt_m6
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23403
1	29

Common Values
Chart

Value	Count	Frequency (%)
0	23403	99.9%
1	29	0.1%

pit_des_upg_cnt_y1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23388
1	18
5	14
2	12

Frequencies
Length

Value	Count	Frequency (%)
0	23388	99.8%
1	18	0.1%
5	14	0.1%
2	12	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_des_mall_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23431
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	23431	> 99.9%
1	1	< 0.1%

pit_des_mall_cnt_m6
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23406
1	23
2	3

Frequencies
Length

Value	Count	Frequency (%)
0	23406	99.9%
1	23	0.1%
2	3	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_des_out_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23426
1	6

Common Values
Chart

Value	Count	Frequency (%)
0	23426	> 99.9%
1	6	< 0.1%

pit_des_out_cnt_m6
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23422
1	6
3	2
2	2

Frequencies
Length

Value	Count	Frequency (%)
0	23422	> 99.9%
1	6	< 0.1%
3	2	< 0.1%
2	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_des_out_cnt_y1
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23398
1	28
2	4
3	2

Frequencies
Length

Value	Count	Frequency (%)
0	23398	99.9%
1	28	0.1%
2	4	< 0.1%
3	2	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_income_cnt_m3
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23300
1	93
2	33
3	6

Frequencies
Length

Value	Count	Frequency (%)
0	23300	99.4%
1	93	0.4%
2	33	0.1%
3	6	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

pit_pay_cnt_m3
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23408
1	24

Common Values
Chart

Value	Count	Frequency (%)
0	23408	99.9%
1	24	0.1%

pit_add_chnl_m3
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	23300
航空累积	118
非航累积	14

Frequencies
Length

Value	Count	Frequency (%)
0	23300	99.4%
航空累积	118	0.5%
非航累积	14	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.016899966
Min length	1

pit_add_chnl_m6
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22841
航空累积	557
非航累积	34

Frequencies
Length

Value	Count	Frequency (%)
0	22841	97.5%
航空累积	557	2.4%
非航累积	34	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.075665756
Min length	1

pit_add_chnl_y1
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	22229
航空累积	1180
非航累积	23

Frequencies
Length

Value	Count	Frequency (%)
0	22229	94.9%
航空累积	1180	5.0%
非航累积	23	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.154020143
Min length	1

pit_add_chnl_y2
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	21143
航空累积	2253
非航累积	35
积分购买	1

Frequencies
Length

Value	Count	Frequency (%)
0	21143	90.2%
航空累积	2253	9.6%
非航累积	35	0.1%
积分购买	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.293060772
Min length	1

pit_add_chnl_y3
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	183.1 KiB

0	20889
航空累积	2398
非航累积	144
积分购买	1

Frequencies
Length

Value	Count	Frequency (%)
0	20889	89.1%
航空累积	2398	10.2%
非航累积	144	0.6%
积分购买	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	1
Mean length	1.325580403
Min length	1

pax_fcny
pax_tax

pax_fcny
pax_tax

pax_fcny
pax_tax

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin	seg_dep_time	pax_fcny	pax_tax	emd_lable	emd_lable2	gender	residence_country	pref_aircraft_y2_1	pref_aircraft_y2_2	pref_aircraft_y2_3	pref_aircraft_y3_1	pref_aircraft_y3_2	pref_aircraft_y3_3	pref_aircraft_y3_4	pref_aircraft_y3_5	pref_orig_y1_1	pref_orig_y1_2	pref_orig_y2_1	pref_orig_y2_2	pref_orig_y2_3	pref_orig_y3_1	pref_orig_y3_2	pref_orig_y3_3	pref_line_y1_1	pref_line_y1_2	pref_line_y2_1	pref_line_y2_2	pref_line_y2_3	pref_line_y2_4	pref_line_y3_1	pref_line_y3_2	pref_line_y3_3	pref_line_y3_4	pref_city_y2_1	pref_city_y2_2	pref_city_y2_3	pref_city_y3_1	pref_city_y3_2	pref_city_y3_3	recent_flt_day	pref_orig_city_y2	pref_orig_city_y3	pref_dest_city_y1	pref_dest_city_y2	pref_dest_city_y3
0	9612c51f08718e48b1361e415ef55be9	93d0aceeaef3f85264e5c5b5b1148a90	JFK	AB1006	J	2018/12/16 20:00	4161.0	584.43	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	c7ca533cd9da4c4bf3d597248f90bc6e	6930f6fa59d86c11fa28c610ab6f56a5	JFK	AB1006	J	2019/2/18 20:00	1670.0	248.80	1	0	0	0	0	0	0	0	0	0	0	0	PVG	JFK	PVG	KHN	JFK	PVG	KHN	JFK	TPE-PVG	PVG-JFK	TPE-PVG	SZX-KHN	PVG-JFK	0	TPE-PVG	SZX-KHN	PVG-JFK	0	0	0	0	0	0	0	0	0	0	New York	New York	New York
2	bd2cb6b0dd56fb3de6f7c018296a07e2	da73afa8f6ededd29d67a9331dccdbe9	LAX	AB1009	Y	2018/3/9 13:20	243.0	301.31	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3	65657872fe131ea7651565638dcb5683	dc31eead23771810dbb586ad236ade3b	LAX	AB1009	Y	2018/1/2 13:20	1362.0	454.16	0	0	0	0	0	0	0	773	773	773	773	773	0	0	0	0	0	PVG	LAX	0	0	0	0	0	0	0	LAX-PVG	PVG-LAX	0	0	0	0	0	PVG	LAX	0	2018/1/2	0	Los Angeles	0	0	Los Angeles
4	722261f7b860b183da9fe0b6630b6dbf	7689603247539830a08d945cb1a57823	JFK	AB1010	Y	2018/7/6 11:30	675.0	284.11	1	1	M	中国	773	33E	325	773	33E	325	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	PVG	JFK	ICN	PVG	JFK	ICN	2018/7/6	Shanghai	Shanghai	0	0	0
5	921275b898d68fddf19e9c6587155ade	519e0384d67f770581cb79f8bc5ee58f	LAX	AB1009	Y	2019/3/24 13:20	250.0	298.23	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
6	5fa77ea584f557d2f95a100054d1fffa	6c064c209c0d0720ad9df0e0a1c37115	JFK	AB1006	Y	2019/8/18 19:10	700.0	292.73	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7	2cd73d0759be784227b6294ad11a2ae3	6da54673b857648cf5408d7688c7cdee	JFK	AB1006	Y	2017/7/7 19:10	1222.0	453.66	1	1	0	0	0	0	0	773	773	773	773	773	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	PVG	JFK	0	2018/1/3	0	TORONTO	0	0	0
8	ff9abe74f4bb52e3a9e083a04686f471	179deabcf8b9d8c84cfe2a12b7a4f30c	JFK	AB1006	Y	2018/12/8 19:30	200.0	299.61	0	0	0	0	0	0	0	0	0	0	0	0	0	0	PVG	MNL	JFK	PVG	MNL	JFK	0	0	PVG-MNL	JFK-PVG	MNL-PVG	PVG-JFK	PVG-MNL	JFK-PVG	MNL-PVG	PVG-JFK	0	0	0	0	0	0	0	0	0	0	Shanghai	Shanghai
9	0226ea2a797da4ae4376a506475bc6c9	bce11c2d28ba6ac88b72e4713461409d	LAX	AB1008	Y	2017/5/25 21:00	302.0	441.96	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	PVG	LAX	KIX	0	0	0	0	0	0	LAX-PVG	KIX-PVG	PVG-LAX	PVG-KIX	0	0	0	0	0	0	0	0	0	0	0	Shanghai

Last rows

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin	seg_dep_time	pax_fcny	pax_tax	age	birth_date	nation_name	province_name	member_level	enroll_chnl	pref_orig_y1_1	pref_orig_y1_2	pref_orig_y1_3	pref_orig_y1_4	pref_orig_y1_5	pref_orig_y2_1	pref_orig_y2_2	pref_orig_y2_3	pref_orig_y2_4	pref_orig_y2_5	pref_orig_y3_1	pref_orig_y3_2	pref_line_y1_1	pref_line_y1_2	pref_line_y1_3	pref_line_y1_4	pref_line_y1_5	pref_line_y2_1	pref_line_y2_2	pref_line_y2_3	pref_line_y2_4	pref_line_y2_5	pref_line_y3_1	pref_line_y3_2	pref_dest_city_y1	pref_dest_city_y2	pref_dest_city_y3
23422	c0e6e0aee4da3d4310abc315fc77c375	09a2c70febc40412217b78e657c3e0bf	SYD	AB1007	Y	2017/7/24 20:20	630.0	236.50	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23423	e9bca8b0642c41c75b4dde411fb9e8bc	5ee57b5109b5992e40feac4b6160e7a4	SYD	AB1007	Y	2017/5/3 21:10	689.0	108.10	41-50	1976/9/3	澳大利亚	NSW	STD	网站	SYD	SYD	SYD	SYD	SYD	SYD	SYD	SYD	SYD	SYD	SYD	PVG	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	PVG-SYD	SYD-PVG	SYDNEY	SYDNEY	SYDNEY
23424	f41fa8224df1b94b0abc2c815faa2ab4	88652ef0e2be40bf359e6841e8a269d9	SYD	AB1007	Y	2017/5/15 20:20	406.0	252.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23425	fd2b090b4315e7bd6fcb09beb799d918	07ac63d6314f9cf220c5f16ce6c33f63	SYD	AB1007	Y	2017/5/15 20:20	406.0	252.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23426	b2b974a800ce533fd87b3b26a67a3751	c12e05250dfc3b4b8d82a47533c87219	SYD	AB1007	Y	2017/4/23 20:20	810.0	109.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23427	ec988e914b272ad74634c52b71e84ea8	e61b68ce193bce838436620230ce94e1	SYD	AB1007	Y	2017/8/1 20:20	807.0	486.50	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23428	fa23535ab2ca52589303bd265ee6d382	fdd824109fccadfbcba782aaae72484f	SYD	AB1007	J	2017/3/25 20:20	2218.0	312.90	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23429	623d32d20af6c9752d8eef46efe95c09	ef53ebb9358d5c7b013f6aed92d78a42	SYD	AB1007	J	2017/3/25 20:20	2218.0	312.90	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23430	dadbf45dde7347740b0294c2c0913100	5fe336074ba73e83e12dccb31c33fe40	SYD	AB1007	J	2017/3/25 20:20	2218.0	312.90	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
23431	d4ca366192c096cdda1be87ad0bb89b5	b3981b746d87f6fcea1dba9059d6678f	SYD	AB1007	J	2017/2/26 20:20	4900.0	744.76	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Most frequent

	pax_name	pax_passport	seg_route_to	seg_flight	seg_cabin	seg_dep_time	pax_fcny	pax_tax	emd_lable	gender	age	birth_date	residence_country	nation_name	member_level	enroll_chnl	pref_aircraft_y2_1	pref_aircraft_y2_2	pref_aircraft_y2_3	pref_aircraft_y3_1	pref_aircraft_y3_2	pref_aircraft_y3_3	pref_orig_m3_1	pref_orig_m3_2	pref_orig_m6_1	pref_orig_m6_2	pref_orig_y1_1	pref_orig_y1_2	pref_orig_y2_1	pref_orig_y2_2	pref_orig_y3_1	pref_orig_y3_2	pref_line_m3_1	pref_line_m3_2	pref_line_m6_1	pref_line_m6_2	pref_line_y1_1	pref_line_y1_2	pref_line_y2_1	pref_line_y2_2	pref_line_y3_1	pref_line_y3_2	pref_city_y2_1	pref_city_y2_2	pref_city_y3_1	pref_city_y3_2	recent_flt_day	pref_orig_city_y2	pref_orig_city_y3	pref_dest_city_m3	pref_dest_city_m6	pref_dest_city_y1	pref_dest_city_y2	pref_dest_city_y3	count
22	6b86a19aa6066d3dc873968b11d41192	884c0ba08efca37c02e24cde825329a0	SYD	AB1013	Y	2018/12/31 0:05	64000.0	30730.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	3
31	9918cf4291011b61d3febbd100ffa217	c135041bc1432777347cdea5d7c83534	SYD	AB1013	Y	2018/12/31 0:05	64000.0	30730.00	0	M	0	0	中国	0	0	0	773	325	0	773	325	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	SYD	PVG	SYD	PVG	2018/12/31	Tokyo-Haneda	Tokyo-Haneda	0	0	0	0	0	3
0	0885c5d0f27de2eeefdc2188f3d47593	48a95f49eecf1f4ce9dd5cef47300a3e	JFK	AB1006	Y	2017/12/31 20:00	1120.0	264.36	0	M	0	0	中国	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2
1	0b9ee3513deed38343af86b7776542bc	cad5d96459988380bdf8dea3e22f5bf6	SYD	AB1013	Y	2018/12/27 0:05	54000.0	31940.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2
2	0cff56bcf8bdea7494be22243d49b89d	83f529b67971a7a1ec5ff782152cd169	JFK	AB1010	Y	2018/1/17 11:30	185.0	279.56	0	0	21-30	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2
3	1452266b08c7bc2ca8a16c6423057579	2180a07120bee89f9d31808816722aa2	SYD	AB1007	Y	2018/2/24 20:20	1338.0	156.92	0	0	21-30	1994/8/10	0	中国	STD	网站	0	0	0	0	0	0	SYD	PVG	SYD	PVG	SYD	PVG	SYD	PVG	SYD	PVG	SYD-PVG	PVG-SYD	SYD-PVG	PVG-SYD	SYD-PVG	PVG-SYD	SYD-PVG	PVG-SYD	PVG-SYD	SYD-PVG	0	0	0	0	0	0	0	SYDNEY	SYDNEY	SYDNEY	SYDNEY	SYDNEY	2
4	1c7a74137600a956bc49dba4e2f0f3fc	1dc1df08b94cb7702e1bf62f1714a861	SYD	AB1007	Y	2020/3/1 20:20	214.0	436.30	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2
5	1c978bb5f396517df6ad3a64aa57586b	5402838367ce8d9899d0b40b0d8704b0	JFK	AB1006	J	2018/11/12 19:30	3264.0	540.31	0	0	31-40	1984/5/7	0	美国	STD	网站	0	0	0	0	0	0	0	0	0	0	0	0	PVG	JFK	PVG	JFK	0	0	0	0	0	0	JFK-PVG	PVG-JFK	JFK-PVG	PVG-JFK	0	0	0	0	0	0	0	0	0	0	New York	New York	2
6	260fcd26dd4f11aa99a7796124bf19a1	a3a9c702797773cdaf845a416a980b5e	SYD	AB1007	Y	2018/12/29 20:20	62500.0	21910.00	0	0	0	0	0	0	0	0	773	33L	33H	773	33L	33H	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	PVG	SYD	PVG	SYD	2019/1/2	MELBOURNE	MELBOURNE	0	0	0	0	0	2
7	2716601ef58972c314a9452cf38e0d6b	127107ec71f9b88f3d7198ac49b7f197	JFK	AB1010	J	2019/1/29 11:30	2800.0	280.13	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent